Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bmassey
Starting Member
22 Posts |
 Posted - 2008-04-15 : 14:06:54
|
| My company is trying to standardize on what data type should be used for storing money. Some of our databases use decimal and some use money. What is the general best practice for this scenario? |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-04-15 : 14:24:48
|
money seems appropriate to me...
elsasoft.org |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-04-15 : 20:33:21
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47222 |
|
|
|
bmassey
Starting Member
22 Posts |
Posted - 2008-04-16 : 06:57:21
|
| Thanks for the feedback! |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-04-16 : 07:40:24
|
Glad2help  |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-04-17 : 03:29:46
|
if you are building an app for the gov't, better use the bigmoney datatype.for non-profits, use tinymoney.
elsasoft.org |
|
|
|
|
|
|
Proper data type to store Money in?