money and smallmoney (T-SQL)

Monetary data types for representing monetary or currency values.

money
Monetary data values from -2^63 (-922,337,203,685,477.5808) through 2^63 - 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit. Storage size is 8 bytes.
smallmoney
Monetary data values from - 214,748.3648 through +214,748.3647, with accuracy to a ten-thousandth of a monetary unit. Storage size is 4 bytes.
See Also
ALTER TABLE DELETE
CAST and CONVERT INSERT
CREATE TABLE Monetary Data
Data Type Conversion SET @local_variable
Data Types UPDATE
DECLARE @local_variable Using Monetary Data

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.