I tried to insert new values (new rows into table) to Table A according to specific Select query on table A
Table B holds many datarows. I just want to add more from Table A to it.
Both tables are with the same columns (and properties).
I tried this :
INSERT INTO B_Archive
WHERE (YEAR(t_date) = 2009)
I got an error:
An explicit value for the identity column in table 'Tnuot_Archive' can only be specified when a column list is used and IDENTITY_INSERT is ON.
View Complete Post