Exact Numeric Data Types in SQL Server

Reflection of male hacker coding working hackathon at laptop
Hero Images / Getty Images

The exact numeric data types are the most common SQL Server data types used to store numeric information. The approximate numeric data types provide less precision and are less commonly used.

Data types in the exact numeric category include:

  • int variables store 4-byte whole numbers ranging from -2,147,483,648 to 2,147,483,647.
  • bigint variables store 8-byte whole numbers ranging from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.
  • smallint variables store 2-byte whole numbers ranging from -32,768 to 32,767.
  • tinyint variables store 1-byte whole numbers ranging from 0 to 255.
  • decimal and numeric variables are functionally equivalent and store numbers of fixed precision and scale. Precision indicates the maximum number of digits that may be stored (including those before and after the decimal point. Scale indicates the number that may be stored to the right of the decimal point.
  • money variables store 8-byte currency values ranging from -922,337,203,685,477.5808 to 922,337,203,685,477.5807. They may reflect any currency type.
  • smallmoney┬ávariables store 4-byte currency values ranging from -214,748.3648 to 214,748.3647. They may reflect any currency type.