--建立新表a2并且复制a1表结构到a2
select top 0 * into a2 from a1
--a2表中插入与a1相同数据
insert into a2 select * from a1
--复制并插入数据
select * into a2 from a1
select * from a2
select top 0 * into a2 from a1
--a2表中插入与a1相同数据
insert into a2 select * from a1
--复制并插入数据
select * into a2 from a1
select * from a2