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:
| Range | Storage |
|---|---|
| -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 |