SQL Server Max SmallInt Value

The maximum value for a smallint in SQL Server is:

-32768 through 32767

And the byte size is: 2 bytes

other maximum values:

BigInt: -9223372036854775808 through 9223372036854775807 (8 bytes)
Int: -2147483648 through 2147483647 (4 bytes)
TinyInt: 0 through 255 (1 byte)

Featured Articles

 Site Author

  • Thanks for visiting!