将查询结果放到一张表中
insert into newTable (column1,datecolumn) select column1,getdate() from oldTable
将查询结果放到一张不存在的表中
select * into newTable from oldTable