Monetary data represents positive or negative amounts of money. Monetary data is stored using the money and smallmoney data types in Microsoft® SQL Server™. Monetary data can be stored to an accuracy of four decimal places. Use the money data type to store values in the range from -922,337,203,685,477.5808 through +922,337,203,685,477.5807 (requires 8 bytes to store a value). Use the smallmoney data type to store values in the range from-214,748.3648 through 214,748.3647 (requires 4 bytes to store a value). If a greater number of decimal places are required, use the decimal data type instead.
| money and smallmoney | Using Monetary Data |
| Using Data Types |