sqlserver
创建新表和数据
select * into newtable from oldtable where col=xxx
插入数据
insert into table1 (col1,col2) select (col1,col2) from table2
条件成功复制表结构和数据 不成功只是复制表结构
创建空表
create table newtable as select * from oldtable where 1!=1;
创建表和数据
create table newtable as select * from oldtable where 1=1;