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