动态sql问题
是否动态sql里不能使用MSSQL的自身函数?
例如
declare @s varchar(8000)
set @s = ''
select @s = @s + ','+a.ModelDate+' = sum (case a.modelDate when '''+a.modelDate+''' then a.qty else 0 end )'
from #proSMSsale a group by a.ModelDate order by a.ModelDate
exec('select a.provinceCode '+@s+ 'from #proSMSsale a group by a.provinceCode order by
charindex('',''+a.provincecode+'','','',Beijing,TianJin,HeBei,HeiLongJiang,JiLin,LiaoNing,ShanXi,ShanDong1,ShanDong2,ShanX,XinJiang,ShangHai,JiangSu1,JiangSu2,ZheJiang1,ZheJiang2,AnHui,FuJian,JiangXi,HuBei,HeNan,GuangDong2,GuangDong4,GuangDong1,GuangDong3,GuangXi,HuNan,Guizhou,SiChuan,ChongQing,'')')
charindex 在exec里是无效的么?
谢谢