DIFFERENCE BETWEEN SMALLMONEY AND MONEY DATA TYPE IN SQL SERVER 2005

Similarities & Differences.

1.Both are monetary data types for representing monetary of currency values.

2.Storage size of small money is 4 bytes.

3.Storage size for money is 8 bytes.

4.Minimum value for smallmoney is -214748.3648
Maximum value for smallmonet is 214748.3647

5.Minimum value for money is : -2^63
Maximum value for money is : 2^63 – 1

6.The rule is to always use the data type that will require least
storage size.Means if the monetary value you will store is less than
214748.3647 then you should use smallmoney otherwise you should go with
money data type.

Pawan Kumar
Pawankkmr@hotmail.com

Advertisements