Saturday, May 18, 2013

SQL Server 2012 New Features - Sequence Objects

Sequence objects in SQL Server 2012 are similar to the ones in ORACLE and DB2

Allows to generate numeric values specified at the time of creation of sequence

They are similar to the IDENTITY Column with a difference being IDENTITY column is table specific while sequence objects are table independent.

Sequence objects are much faster in generating numbers than IDENTITY

No comments:

Post a Comment