I have two tables that are almost identical.. the only difference is that tableB has additional field with Identity ON...
I tried to run this:
insert into tableB
select * from tableA
I want to avoid specifying all the fields... but I get this error:
An explicit value for the identity column in table 'tableB' can only be specified when a column list is used and IDENTITY_INSERT is ON.
I also tried to run SET IDENTITY_INSERT TableB ON before running the query but same result...
is there any way to do this?