SQL Server integer datatypes. : integer « Data Types « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Data Types
  3. integer
Datatype              Range                                Storage (bytes)

bigint                -2^63 to 2^63-1                      8

int                   -2^31 to 2^31-1                      4

smallint              -2^15 to 2^15-1                      2

tinyint               0 to 255                             1

money                 -922,337,203,685,477.5808 to         8
                      922,337,203,685,477.5807,
                      with accuracy of one
                      ten-thousandth of a monetary unit




smallmoney            -214,748.3648 to 214,748.3647,       4
                      with accuracy of one
                      ten-thousandth of a monetary unit








5.13.integer
5.13.1.SQL Server integer datatypes.
5.13.2.A SELECT statement that retrieves rows with zero values
5.13.3.To use a numeric literal, enter the number without quotes.
5.13.4.Using AVG on INTEGER values.
5.13.5.Convert the return datatype from INTEGER to FLOAT by multiplying the data in the INTEGER column by 1.0 to convert to FLOAT.
5.13.6.int OUTPUT parameter
5.13.7.Conversion failed when converting the varchar value '97/522' to data type int.
5.13.8.Using convert to convert integer to characters
5.13.9.Count int1 values (implicitly non-null)