Wednesday, March 7, 2012

How to set MONEY data-type to scale 2

Hi All,

Is there a way to set a MONEY datatype to a scale (decimal places) of 2?
The default is set to 4 and I can't seem to find any resources on how to change it.

Do I have to add a check constraint to manually round to 2 decimals??
That seems unneccessary... but if it is, boo-urns to sql server.

thanks!alter the column to decimal(15,2)?

Why is 4 positions a problem?

No comments:

Post a Comment