how can i copy the table from one database to another in SQL?

1 ⤊

how can i copy the table from one database to another in SQL?

i need the sql query to copy the content of tables from one database to another database.

2007-10-15 22:25:53 · 2 answers · asked by Vijee 1 in Computers & Internet ➔ Programming & Design

2 answers

Use the SELECT INTO statement, you may have to use a Linked Server and the "TargetServer..TargetTable" syntax. Don't forget to look at Data Transformation Services (DTS) packages which are designed to do this job efficiently.

_

2007-10-15 22:44:28 · answer #1 · answered by SadButTrue 4 · 1⤊ 0⤋

This link has the code at the bottom of the page

2007-10-16 05:40:24 · answer #2 · answered by AnalProgrammer 7 · 0⤊ 2⤋