Wednesday, 22 July 2015

TSQL: Referencing Sequence Objects

Introduced in SQL Server 2012


create sequence AdSequence
as int
start with 1
increment by 1
no cycle
no cache;

select nextvalue fro AdSequence


select nextvalue fro AdSequence
go 50

TOBETESTED...

No comments:

Post a Comment