将查询结果插入新表中:
select distinct * into #tmp from tb_old
将查询结果插入已存在的表中
insert into tb_old1 (col_1,col_2) select col_1,col_2 from tb_old2