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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Money or Numeric

Author  Topic 

mayoorsubbu
Yak Posting Veteran

95 Posts

Posted - 2011-11-30 : 21:07:53
Dear All,

In an accounting database which one of the two datatypes, Money/Numeric is better. I have read a lot on the net and found most warning against the use of money datatype. Please clarify.

Thanks

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-11-30 : 22:20:37
here is an interesting article on the subject
http://sqlblog.com/blogs/aaron_bertrand/archive/2008/04/27/performance-storage-comparisons-money-vs-decimal.aspx


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

mayoorsubbu
Yak Posting Veteran

95 Posts

Posted - 2011-12-01 : 08:48:48
Thanks Khtan
Go to Top of Page

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2011-12-01 : 12:43:48
It's pretty simple. If you are modeling something and that "thing" represents a currency, then, in general, you should use an appropriate datatype, like MONEY.
Go to Top of Page
   

- Advertisement -