SQL Server Max SmallInt Value

Posted on May 13, 2010 by Derek Dieter
0
2

« SQL Server Max TinyInt Value

Simulate ROW_NUMBER in SQL 2000 »

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)

Post a comment

Featured Articles

How to cache stored procedure results using a hash key There are a lot of different design patterns that lend themselves to creating
SQL Server Database Optimization Guide In the troubleshooting guide we went over the different physical bottlenecks that can
Yet Another Temp Tables Vs Table Variables Article The debate whether to use temp tables or table variables is an old
Using Union Instead of OR Sometimes slow queries can be rectified by changing the query around a bit.

Site Author

Thanks for visiting!

Resources