Community

Understanding Sequence Object in SQL Server Denali

(Arshad Ali) Until SQL Server 2008 R2, the Identity column was used to generate sequential numbers to identify records in a table, mostly used as a primary/foreign key. The scope of the identity column is the table on which it has been created, and the next sequential number is created when the DML

Read More - Register for Free Membership