Saturday, September 7, 2013

How to copy table form one database to another in SQL Server


Copying table from one database to another database in SQL Server 

This is very simple task.

STEP 1: select columns ( * or required columns ) from existing table.
STEP 2: Now insert this result table into new table on another table database.

Ex:
select  *
into    ToDB.dbo.table2
from    FromDB.dbo.Table1

No comments:

Post a Comment

amazon

Sukanya Samriddhi Account - SBI

SUKANYA SAMRIDDHI Account information by SBI SUKANYA SAMRIDDHI ACCOUNT : FACILITY AVAILABLE AT ALL BRANCHES OF SBI Sukanya Samriddhi ...