How do you insert into a table that has an identity column aset of rows with predefined values for the identity column.
I have tried to Set Identity_insert off and then insert but it didnt work.
any ideas?SET IDENTITY_INSERT table ON
Insert into table (columns) select * from table2
Showing posts with label predefined. Show all posts
Showing posts with label predefined. Show all posts
Subscribe to:
Posts (Atom)