Question

sqlserver怎么建临时表？

declare @sql varchar(2000)declare @lie varchar(2000)set @sql=''set @lie=''select @sql=@sql+',case when sum(case when pzmc='''+pzmc+''' then sl end) is null then 0 else sum(case when pzmc='''+pzmc+''' then sl end) end as ['+pzmc+']'from Z_YidaiZajiaozhongShengchan  where nian='2008' and jidu='春' and shsftg='通过' group by pzmcselect @lie=@lie+'+case when sum(case when pzmc='''+pzmc+''' then sl end) is null then 0 else sum(case when pzmc='''+pzmc+''' then sl end) end'from Z_YidaiZajiaozhongShengchan  where nian='2008' and jidu='春' and shsftg='通过' group by pzmcexec ('select case when (grouping(tbdw)=1) then ''合计'' else tbdw end as 场别 '+@sql+','+@lie+' as 合计 from Z_YidaiZajiaozhongShengchan where nian=''2008'' and jidu=''春'' and shsftg=''通过'' group by tbdw with rollup') 我想把上面查询出来的结果建成一个临时表或者是视图，应该怎么建啊？

Answer 1

select 字段名 into #临时表名 from 所查询的表

Answer 2

create view 视图名as
这里写上你查询出上面结果的查询语句