declare @sql nvarchar(4000)
declare @num int
set @num=1
set @sql='select TF_ID'
select @sql=@sql+',max(case when Winding='''+CAST(Winding as nvarchar(10))+''' then cast(Winding as varchar(10)) else null end) as [Temp'+@num+'],
max(case when Winding='''+CAST(Winding as nvarchar(10))+''' then cast(Laps as varchar(10)) else null end) as [Temp,Laps],
max(case when Winding='''+CAST(Winding as nvarchar(10))+''' then cast(Wire as varchar(10)) else null end) as [Temp,Wire]'
from (select Winding from wound b where TF_ID=1) as t
set @sql=@sql+'from Wound where TF_ID=1 GROUP BY TF_ID'
exec (@sql)我想在 Temp加数字。 as [Temp'+@num+'],这样写出错。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货