SQL imports data from one library into a table of the same structure in another library

SQL 2008 imports data from one table into a table with the same structure in another library

Use library 1

Go

Insert into Library 1.dbo. Table 1 Select * FROM Library 2.dbo. Table 1

There is a problem here: if the primary key of this table or one of the columns uses IDENTITY (total) self-growth, but you want to manually refer to this column for timing

An error will occur. My practice is to first Insert Table 1 of the self-increment to cancel, insert the successful after the change.

SQL imports data from one library into a table of the same structure in another library