In an older article
on my blog, I wrote on how someone can mimic the operation of Sequence Objects using other alternative ways.
With the general availability of SQL Server 2012
, now Sequence Objects are here!
So, how can we use a Sequence Object
in SQL Server 2012?
Let's skip the words and move directly to an example:
--Select the proper database
-- Create the Sequence Object (TestSeq is my Sequence's name)
CREATE SEQUENCE TestSeq
START WITH 0
INCREMENT BY 1
--To get the next value from the Sequence
SELECT NEXT VALUE FOR TestSeq
--To drop the sequence
DROP SEQUENCE TestSeq
--To reset the sequence
--You can replace 0 with any other constant value
ALTER SEQUENCE TestSeq
RESTART WITH 0
Simple enough right?
Enjoy Sequence objects in SQL Server 2012! :)
Labels: SQL Server, SQL Server 2012, SQL Server Development