Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 |
Remarks
The money and smallmoney data types are accurate to a ten-thousandth of the monetary units that they represent.
See Also
Reference
ALTER TABLE (Transact-SQL)
CAST and CONVERT (Transact-SQL)
CREATE TABLE (Transact-SQL)
Data Types (Transact-SQL)
DECLARE @local\_variable (Transact-SQL)
DELETE (Transact-SQL)
INSERT (Transact-SQL)
SET @local\_variable (Transact-SQL)
UPDATE (Transact-SQL)
Other Resources
Data Type Conversion (Database Engine)
Using Monetary Data