a) 插入新表
select *
into newtable
from table
b) 插入已经存在的表
insert into table
select * from table2 where...
