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 » denali » SQL Server 2011 » SQL 11   (RSS)
  • 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