How to copy one table from one database to a table in another database

How to copy one table from one database to a table in another database Share | 2013-09-11 17:13 Anonymous | browse 13,763 times

How to copy one table from one database to another in a table in a different database is not the same as the column names of the two tables. Do you know anything about that? SQL statements directly lead to the past.

2013-09-12 20:26 netizens adopted Enthusiastic Netizen

If there is no table with the same name in another library
SELECT * into B database. dbo.a table from a database. DBO.A table WHERE Condition

If you are appending to another table
Inert into B database. dbo.a table
SELECT * from a database. DBO.A table WHERE Condition

Format for different databases: [Database name. owner name. Table name]

INSERT into Database b.dbo. Table 2
SELECT * from Database a.dbo. Table 1 WHERE ....

Share

Comments | 4 Other similar issues

How to copy one table from one database to a table in another database