SSRS Interview Question:

What happens when my integer IDENTITY runs out of scope?

Submitted by: Administrator

An integer data type can have a variety of IDENTITY values like int, bigint, tinyint etc.

To avoid the integer IDENTITY to run out of scope, BIGINT should be used as the data type or DECIMAL (38,0)

CREATE TABLE sample_t ( col1 BIGINT IDENTITY(-9223372036854775808, 1) )
Submitted by: Administrator