SqlServer复制表

1、表不存在同时创建表

1.1要创建一个表的副本最简单的方法是使用 T_SQL语句

select * into dbo.MyTable from dbo.Area_Circle

select * into syn_xj_student2 from syn_xj_student where 1=2

将表dbo.Area_Circle复制到dbo.MyTable上

1.2也可以从原始表中特定子集创建新表

select CircleIndexID,CircleName,CircleArray into mytable8 from dbo.Area_Circle

2、相同结构表已存在

2.1复制表数据，并排除俩表中相同的数据：

insert into syn_xj_student2 select * from syn_xj_student where f_id not in (select f_id from syn_xj_student2)