select * into [destination database.dbo.destination table]
from [source database.dbo.source table]Example:select * into Mydatabase2.dbo.employee_backupfrom mydatabase1.dbo.employee
No comments:
Post a Comment