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

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)

Concepts

Data Type Conversion (Database Engine)

Using Monetary Data