money and smallmoney (Transact-SQL)
SQL Server 2005
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 |
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
