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