SQL Server A libraries and B libraries on the same servers

Method 1:

Insert into A.dbo.users (FIELD1,FIELD2,FIELD3) SELECT * FROM B.dbo.users

Note: The same server, A and B are different databases, such as the table is automatically marked, you can first cancel the automatic indicator, and then execute.

Method 2:

A. Copying the table Dbo.users in database a to database B requires the first step: right-click Edit Table Script->create to the new Query editing window, copy the content!

B. in the query, select database B, right-select new query, and paste in the copied code. Remember to remove the line code from use B and select Execute. ----"Table structure.

Within database B, a table has been added Dbo.users but without data, you need to go through the steps: (1) Import the data in database B, right-click Tasks, and import the tables in. (2) Note: Select source table, click Edit Map, select Enable identity insertion, OK, next

The import succeeds.