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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment