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