Showing posts with label money. Show all posts
Showing posts with label money. Show all posts

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)