[转]如何拷贝一个 SQL Server 的表

我们也可以只拷贝某些字段：

1 select col1, col2, col3 into <destination table>
2 from <source table>
3  
4 Example:
5 Select empId, empFirstName, empLastName, emgAge into employee_backup
6 from employee

下面的方法仅拷贝表结构，不包含数据：

1 select * into <destination table> from <source table> where 1 = 2
2  
3 Example:
4 select * into employee_backup from employee where 1=2

而下面方法可将表拷贝到另外的 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

[转]如何拷贝一个 SQL Server 的表

标签：