Tag Archives: sp_sequence_get_range

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 and DB2. Sequence is a User Defined object that generates the numeric values based on the values specified. [...]