THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » t-sql » SEQUENCE   (RSS)
  • Utility to reset a sequence next value based on a table/sequence relationship

    So I was building a database the other day, and I used sequence objects for all of the defaults because it was FAR easier to load data into the table not needing to set identity_insert on and off over and over and over. Worked great. Went through all of my tests, everything was great. Got out Redgate Data Generator to load up a few hundred ...
    Posted to Louis Davidson (Weblog) by drsql on July 22, 2015
  • SQL Server v.Next (Denali) : Deriving sets using SEQUENCE

    One complaint about SEQUENCE is that there is no simple construct such as NEXT (@n) VALUES FOR so that you could get a range of SEQUENCE values as a set.  In a previous post about SEQUENCE, I mentioned that to get a range of rows, you should use the system stored procedure sys.sp_sequence_get_range.  If you've tried this stored ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 13, 2010
  • SQL Server v.Next (Denali) : Using SEQUENCE

    SQL Server 2011 introduces a feature that Oracle professionals will certainly recognize: SEQUENCE.  SEQUENCE allows you to define a central place where SQL Server will maintain a counter of values for you.  The last-used value is stored in memory and so no storage is required.  Here is an example: CREATE SEQUENCE ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 11, 2010
Privacy Statement