sql-从查询结果创建一个永久表
时间:2022-03-14 04:45
语法:
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]
时间:2022-03-14 04:45
语法:
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]