How to Create and use 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.
http://www.sqlserver-training.com/how-t ... sql-server
What is the Difference between Identity and Sequence in SQL Server?
http://www.sqlserver-training.com/what- ... d-sequence