Tuesday, 24 June 2014

Copy a table across two database in the same Sql Server.

select * into [destination database.dbo.destination table]

from [source database.dbo.source table]
 
Example:
select * into Mydatabase2.dbo.employee_backup
from mydatabase1.dbo.employee

No comments:

Post a Comment