T-SQL Tutorial

Bigint - TSQL Tutorial


On Transact SQL language the bigint is an numeric data type. On this page you can read about max value and find an simple example.

Bigint syntax:

RangeStorage
-2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)8 Bytes

Bigint example:

USE model;
GO
CREATE TABLE test_table ( a bigint );
GO
INSERT INTO test_table VALUES (9223372036854775807);
GO
SELECT a FROM test_table;
GO

Results
9223372036854775807