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 |
|
Utpal
Posting Yak Master
179 Posts |
 Posted - 2002-03-08 : 05:15:53
|
| Hi everybody, Is there any reason why I should use the Money data type instead of Numeric(n,2) for financial value fields ? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-08 : 07:46:03
|
| Money (8 bytes) and smallmoney (4 bytes) are scaled integers with 4 decimal precision; this allows for faster calculations that are more accurate (fewer rounding problems), and have smaller storage requirements than the equivalent numeric/decimal datatypes. Look in Books Online for more details.It might be a personal preference, but I find it more descriptive to see "money" as a datatype; it makes it pretty clear that the column holds financial data. |
 |
|
|
Utpal
Posting Yak Master
179 Posts |
Posted - 2002-03-09 : 00:01:52
|
| Thanks ! |
|
|
|
|
|
|
Money data type