在线等，exec执行说不是有效标识符

[sra]

declare @sql1 varchar(1000)
set @sql1='SELECT c.SignTime,sum(b.price) as PriceSum FROM table1 AS a INNER JOIN table2 AS b ON a.id=b.ServiceID INNER JOIN table3 AS c ON a.BasicInfoID=c.id WHERE b.ServiceTableName=''aaa'' AND a.BasicInfoID in (SELECT id FROM table3 WHERE State=1 AND Realcontract=1) GROUP BY c.SignTime'
exec @sql1

报错说“不是有效的标识符。”，请问该如何解决？

[Limpire]

declare @sql1 varchar(1000)
set @sql1='SELECT c.SignTime,sum(b.price) as PriceSum FROM table1 AS a INNER JOIN table2 AS b ON a.id=b.ServiceID INNER JOIN table3 AS c ON a.BasicInfoID=c.id WHERE b.ServiceTableName=''aaa'' AND a.BasicInfoID in (SELECT id FROM table3 WHERE State=1 AND Realcontract=1) GROUP BY c.SignTime'
exec (@sql1)

[Limpire]

exec @sql1 --> exec (@sql1)

[sra]

厉害，兄台牛人。结贴

[「已注销」]

好

[junmei_]

遇见同样问题

[chenhongcoo]

真是及时雨 刚遇到这个问题 牛人早有答案 看来不虚此行

[johnnyuqx]

学习了

[qiubgstudy]

搞了半天终于出来了。