Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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