What is Sequence in SQL Server ?

Leave a comment (0) Go to comments

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.
  • Sequence can be generated either in ascending or descending order.
  • Sequence is not associated to table like IDENTITY.
  • Sequence are much faster in generating numbers compared to IDENTITY.

Please check the following Post

Note : sp_sequence_get_range is system proc which reads a range of numbers from a number sequence object in SQL Server DENALI. [More Information]

Subscribe to this Blog via Email:

Click here to Subscribe to FREE email updates from "DBATAG ", so that you do not miss out anything on SQL Server !!!


EOF - What is Sequence in SQL Server ?, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.