We have a database table where we have a column set as Primary Key, Identity ON and auto incremented by 1. By any chance we need to insert few records into this table (including the Primary Key column) by selecting from some other existing. What should we do?
We will remove the Identity for that column manually, import records (INSERT INTO …. SELECT ….) and finally add Identity to the column back again?