SQL Serve create sequence

Oracle has sequence functionality, and SQL Server-like functionality is implemented using the identity column, but with great limitations.

In 2012, Microsoft finally increased the sequence object, the function and performance have been greatly improved.

SQL Server 2012 Sequence

Configuration Properties

1. Query the next value of a sequence

Select Next value for Mysequ

2. Get the properties of a sequence

SELECT * from sys.sequences where name= ' mysequ '

3. Sequences can be shared

4. Sequence can be re-set the initial value

5. Can be used directly in the query

6.