declare @S nvarchar(50)
set @s='select Tlanguage'
select @s=@s+' ,['+Flanguage+']=sum(case when Flanguage='''+Flanguage+''' then Price else 0 end ) '
from newTrans 请教各位大哥 这里@s是啥意思 为什么要@s=@s 而且如果把=@s换成='select Tlanguage' 得到的结果不一样 为什么啊?
set @s='select Tlanguage'
select @s=@s+' ,['+Flanguage+']=sum(case when Flanguage='''+Flanguage+''' then Price else 0 end ) '
from newTrans 请教各位大哥 这里@s是啥意思 为什么要@s=@s 而且如果把=@s换成='select Tlanguage' 得到的结果不一样 为什么啊?
set @s='select Tlanguage' --给变量赋值
select @s=@s+' ,['+Flanguage+']=sum(case when Flanguage='''+Flanguage+''' then Price else 0 end ) '
from newTrans
-- 第一个@S=SLECT TLANGUAGE,....
--第二个@S='SLECT TLANGUAGE'