Money type, can you directly determine the number of decimal places when building a table, such as two decimal places

33213321

Money type, can you directly determine the number of decimal places when building a table, such as two decimal places

fanfan1980

Money doesn't work, fixed to four decimal places

decimal is fine

落日圣骑

You can choose the decimal type, the money type seems to be fixed to 4 decimal places.

fanfan1980

Monetary data
Monetary data represents positive or negative monetary values. In Microsoft® SQL Server&# 8482; 2000, money and smallmoney data types are used to store monetary data. The accuracy of monetary data storage is four decimal places. The range of values ​​that can be stored in the money data type is -922,337,203,685,477.5808 to +922,337,203,685,477.5807 (8 bytes of storage required) The range of values ​​that can be stored in the smallmoney data type is -214,748.3648 to 214,748.3647 (4 bytes of storage required). If the value exceeds the above range, the decimal data type can be used instead.

33213321

Decimal how to use sql statement to determine the decimal places and integer places when building a table