|
|
Posted by David Portas on 10/01/77 11:28
Use DECIMAL / NUMERIC for monetary amounts. Why would you need anything
else?
I haven't seen a recommendation from Microsoft to use MONEY for
monetary amounts. Maybe you could post a reference if you know of one
because I'd like to send some feedback telling them to change it. What
they DO say is "Monetary data types for representing monetary or
currency values", which is a statement not a recommendation.
Knowing the rounding issues I think I'd have to be either careless,
malicious or under written instructions from my boss to use MONEY in
permanent tables in a production database. It does have some potential
uses for formatting and converting values if you need to do such things
in the database.
--
David Portas
SQL Server MVP
--
Navigation:
[Reply to this message]
|