SQL Server Reporting Services Question: Download SSRS PDF
What happens when my integer IDENTITY runs out of scope?
Answer:
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) )
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) )
| Previous Question | Next Question |
| Define Identity and uniqueidentifier property of Column? | What are the advantages of using Stored Procedures? |