Skip Navigation Links
Home
Functions
Tips & Tricks
SQL Server 2005
SQL Server 2008
SQL Server 2012
FAQ
Forums
Practice Test
Bookstore
Tip of the Day : Similarities and Differences Between MONEY and SMALLMONEY Data Types
SQL Server Helper
Home > > Tip of the Day
SQL Server Helper - Tip of the Day

In SQL Server, each column, local variable, expression and parameter has a related data type.  A data type is an attribute that specifies the type of data that the object can hold, such as monetary data.  SQL Server has two data types that can hold monetary data, namely the MONEY data type and the SMALLMONEY data type.

The following article shows the similarities between the MONEY data type and the SMALLMONEY data type.

Similarities

  • Both data types represent monetary or currency values.
  • Both data types are accurate to a ten-thousandth of the monetary units they represent.
  • Both data types does not need to be enclosed in single quotation marks (').
  • A period is used to separate partial monetary units, like cents, from whole monetary units.

Differences

MONEY

SMALLMONEY

Range is from -922,337,203,685,477.5808 to 922,337,203,685,477.5807

Range is from -214,748.3648 to 214,748.3647

Uses 8 bytes of storage

Uses 4 bytes of storage

Back to Tip of the Day List Next Tip