Tag Archives: Sequence in sql server

What is the Difference between Identity and Sequence in SQL Server?

What is Sequence in SQL Server ? SQL Server 2011, Denali, introduces a new alternative to identity columns. There is a new CREATE SEQUENCE statement that can be used to create global sequence generators . This quite similar feature which already exists in Oracle 11g and DB2. What is the Difference between Identity and Sequence [...]