创建表newtable 并完全复制数据1.select [列名][列名]... into 表名 from
2.create table newtable as select * from oldtable如需要进行数据筛选1.select top 0 [列名][列名]... into 表名 from 表名
2.create table newtable as select * from oldtable where 0=1
创建表newtable 并完全复制数据1.select [列名][列名]... into 表名 from
2.create table newtable as select * from oldtable如需要进行数据筛选1.select top 0 [列名][列名]... into 表名 from 表名
2.create table newtable as select * from oldtable where 0=1