Mega Code Archive

 

Categories / MSSQL Tutorial / Data Types

 

SQL Server integer datatypes

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