Sunday, November 21, 2010

What is the difference between smallmoney and money data types in SQL Server 2008?

Well, small money is what I have in my pocket and money is what Bill Gates has in his account.

No, I am kidding. 
The value of money data type ranges from:
-922,337,203,685,477.5808 to 922,337,203,685,477.5807(requires 8 bytes)
(-ve when you enter chapter 5, I am kidding!)

The value of smallmoney ranges from:
- 214,748.3648 to 214,748.3647 (requires 4 bytes)