语法:
select x into new_tableName from ori_tableName
例如:
SELECT [site] ,[day] ,[val]/31.4 [val] into t_init FROM [RainFactor].[dbo].[t_factor] order by [site],[day]
sql-从查询结果创建一个永久表
原文:http://www.cnblogs.com/listened/p/4210009.html