select * into <destination table> from <source table>
Example:
Select * into employee_backup from employee
OR
select only a few columns into the destination table like below
select col1, col2, col3 into <destination table>
from <source table>
Example:
Select empId, empFirstName, empLastName, emgAge into employee_backup
from employee
OR
copy only the structure of the source table.
select * into <destination table> from <source table> where 1 = 2
Example:
select * into employee_backup from employee where 1=2
OR
copy a table across two database in the same SQL Server instance.
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