Friday, 19 October 2012

How to copy a SQL Server table?

 

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