Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

money and smallmoney (Transact-SQL)

Data types that represent monetary or currency values.

Data type

Range

Storage

money

-922,337,203,685,477.5808 to 922,337,203,685,477.5807

8 bytes

smallmoney

- 214,748.3648 to 214,748.3647

4 bytes

The money and smallmoney data types are accurate to a ten-thousandth of the monetary units that they represent.

Community Additions

ADD
Show:
© 2015 Microsoft