stuart-d2
1/14/2016 - 5:07 PM

Insert Into where there is an Identity Constraint

Insert Into where there is an Identity Constraint

Insert Into with Identity Constraints.sql
content_copyfile_download
--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