In this blog, I described how to calculate the
maximum range of integer data types in SQL Server. The int data type is the
primary integer data type in SQL Server.
Int represents an integer value that can be stored in 4
bytes. INT is the short form of integer.
Formula
2^(n-1) is the formula to find the maximum of an INT
data type.
In the preceding formula N (Size in bits) is the
size of data type. The ^ operator calculates the power of the value.
Now determine the value of N in
Bit:
Select
(max_length
*
8)
as
'Bit(s)' from
sys.types
Where
name =
'Int'
Output
32 bits
Determine the maximum range of int
The formula is:
2^(n-1) here N=32
Select
Power(cast(2
as
varchar),(32)
-1)
as 'int
max range' from
sys.types
Where
name =
'Int'
The range of an int data type is -2,147,483,648 to
2,147,483,647.