Skip to content

Instantly share code, notes, and snippets.

@csdear

csdear/Insert Into with Identity Constraints.sql

Created January 14, 2016 17:07
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save csdear/2f7bc04babf63557e96f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save csdear/2f7bc04babf63557e96f to your computer and use it in GitHub Desktop.
Download ZIP
Insert Into where there is an Identity Constraint
Raw
Insert Into with Identity Constraints.sql
--e.g.
SELECT * FROM audit_log_type
SET IDENTITY_INSERT audit_log_type ON
INSERT INTO audit_log_type
(audit_type, description)
VALUES (12, 'Cancel Subscription')
SET IDENTITY_INSERT audit_log_type OFF
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment