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

Read Online SSRS Job Interview Questions And Answers