What happens when my integer IDENTITY runs out of scope?
Submitted by: AdministratorAn 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
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
Top SSRS Questions
☺ | Explain the architecture of reporting services? |
☺ | What is RAID (Redundant Array of Inexpensive disks)? Explain its level? |
☺ | What are the ways to tune Reporting Services? |
☺ | Describe Reporting Lifecycle? |
☺ | What can SQL Server Reporting Services do? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |