Last post Jan 29, 2015 08:40 AM by limno
Jan 28, 2015 06:24 PM|comego|LINK
If I want to store money data, and calculate money, like total, addition, subtraction. but also want to make things easy, what is the data type I should choose for MS SQL?
Jan 28, 2015 06:33 PM|Rechousa|LINK
There is a MONEY and SMALLMONEY data types, but you can also use DECIMAL aka NUMERIC since precising in these data types is exact.
Help this helps,
Jan 29, 2015 08:40 AM|limno|LINK
It depends on how big the value can be. You can use decimal type to choose what you want based on your need.: like decimal (11,4) and you can adjust the digit ). Money data type may have issues and I would like to use decimal if I can.