Skip to content

Instantly share code, notes, and snippets.

@MRdNk

MRdNk/IDENTITY_INSERT.sql

Created March 6, 2013 09:24
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save MRdNk/5098026 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save MRdNk/5098026 to your computer and use it in GitHub Desktop.
Download ZIP
IDENTITY_INSERT example
Raw
IDENTITY_INSERT.sql
-- SET IDENTITY_INSERT to ON.
SET IDENTITY_INSERT products ON
GO
-- Attempt to insert an explicit ID value of 3
INSERT INTO products (id, product) VALUES(3, 'garden shovel').
GO
SET IDENTITY_INSERT products OFF
@MRdNk

MRdNk commented Mar 6, 2013

Copy link
Copy Markdown
Author

Taken from: http://msdn.microsoft.com/en-us/library/aa259221(v=sql.80).aspx

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment