When to use Money data or Decimal Data type in sql server to store costing values? [duplicate]
Decimal
type provides more precision to hold intermediate results to get the results you expect.
Disadvantages of money
datatype:
It is proprietary, so porting it is a pain. It is one of the many "Sybase Code Museum" features from decades ago. Remember the early versions of UNIX?
Writing code in dialect when you don't need to make you sound like a hillbilly to people that speak the language. You are better off with DECIMAL(s,p) so you can use a properly sized column.
It does display and formatting in the back end, with commas and dollar signs. That defeats the purpose of a tiered architecture.
The MONEY data type has rounding errors.
Ref:msdn
You should prefer decimal
as money
datatype is not precise.
You may also check Performance / Storage Comparisons : MONEY vs. DECIMAL by Aaron Bertrand