Skip to content

Instantly share code, notes, and snippets.

@markmo
Created March 19, 2013 02:32
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 markmo/5193281 to your computer and use it in GitHub Desktop.
Save markmo/5193281 to your computer and use it in GitHub Desktop.
Initialize with key
SET IDENTITY_INSERT <table to init> ON
GO
INSERT INTO <table to init>(...)
VALUES (...including key)
SET IDENTITY_INSERT <table to init> OFF
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment