Int - TSQL Tutorial

On Transact SQL language the int is an numeric data type. The int data type is the primary integer data type in SQL Server.

Int syntax:

RangeStorage
-2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647)4 Bytes

Int example:

USE model;
GO
CREATE TABLE myIntTable ( b int );
GO
INSERT INTO myIntTable VALUES (214483647);
GO
SELECT b FROM myIntTable;
GO

Results
214483647