Money Datatypes

Use the money and smallmoney datatypes to store monetary data.

You can use these types for U.S. dollars and other decimal currencies, but SAP ASE provides no means to convert from one currency to another. You can use all arithmetic operations except modulo, and all aggregate functions, with money and smallmoney data.

The money and smallmoney datatypes are Transact-SQL extensions.

• Accuracy
  Both money and smallmoney are accurate to one ten-thousandth of a monetary unit, but they round values up to two decimal places for display purposes. The default print format places a comma after every three digits.
• Range and Storage Size
  The range and storage requirements for money datatypes are:
• Entering Monetary Values
  Monetary values entered with E notation are interpreted as float. This may cause an entry to be rejected or to lose some of its precision when it is stored as a money or smallmoney value.