Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

cannot insert explicit value for identity column in table when identity_insert is set to off

SET IDENTITY_INSERT MyTable ON
 
-- INSERT INTO MyTable...
 
SET IDENTITY_INSERT MyTable OFF
Source by improveandrepeat.com #
 
PREVIOUS NEXT
Tagged: #insert #explicit #identity #column #table #set
ADD COMMENT
Topic
Name
1+5 =