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 |
|
hismightiness
Posting Yak Master
164 Posts |
 Posted - 2007-08-29 : 10:22:41
|
| What significant difference is there between the two data types when we are indeed dealing with monetary values (other than being able to set the precision and scale)? Is there a performance gain from one over the other? Are there administrative-related concerns that should force someone to choose one over the other? Are there any concerns of the MONEY data type being sunsetted by Microsoft anytime in the near future?Can someone please help me out here?[EDIT]I was referring to "fields" in the first sentence when it should've been "data types".[/EDIT]- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://blog.strohlsitedesign.com/http://skins.strohlsitedesign.com/ |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-29 : 10:49:00
|
MONEY (smallmoney and CURRENCY) is faster, since they really are INTs (scaled down by 10000).
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
Ifor
Aged Yak Warrior
700 Posts |
Posted - 2007-08-30 : 04:37:36
|
| For the US MONEY is best as only 4 decimal places are required for rounding.If you want to cope with other currencies you should check with your accountants as some jurisdictions require 5 decimal places for rounding. In this case you will need to use DECIMAL. |
|
|
|
hismightiness
Posting Yak Master
164 Posts |
Posted - 2007-08-30 : 08:26:08
|
| Great advice. Thank you!- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://blog.strohlsitedesign.com/http://skins.strohlsitedesign.com/ |
|
|
|
|
|
|
Data Types: DECIMAL vs. MONEY