Skip to content

Instantly share code, notes, and snippets.

@wullemsb

wullemsb/SQL Server 2012 Create Sequence

Created January 18, 2013 19:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wullemsb/4567357 to your computer and use it in GitHub Desktop.
Save wullemsb/4567357 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SQL Server 2012 Create Sequence
create sequence SampleSequence as int
start with 1 -- Start with value 1
increment by 1-- Increment with value 1
minvalue 0 -- Minimum value to start is zero
maxvalue 100 -- Maximum it can go to 100
no cycle -- Do not go above 100
cache 50 -- Increment 50 values in memory rather than incrementing from IO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment