动态SQL里面设置变量变量值的问题

[windstore]

DECLARE @SUMCOUNT INT
exec('SELECT '+@SUMCOUNT+'=SUM(COUNTS) FROM #TEMP')
update #temp set counts=@SUMCOUNT where code='CC'
SELECT * FROM #temp

我这样写报错，提示语法错误
消息 102，级别 15，状态 1，第 1 行
'=' 附近有语法错误。

[子陌红尘]

DECLARE @SUMCOUNT INT,@SQL NVARCHAR(4000)
SET @SQL=N'SELECT @SUMCOUNT=SUM(COUNTS) FROM #TEMP'
EXEC SP_EXECUTESQL @SQL,N'@SUMCOUNT INT OUT',@SUMCOUNT OUT

update #temp set counts=@SUMCOUNT where code='CC'
SELECT * FROM #temp

[olddown]

把exec('SELECT '+@SUMCOUNT+'=SUM(COUNTS) FROM #TEMP')
中的@SUMCOUNT改成cast(@SUMCOUNT as varchar(20))

[windstore]

搞定 谢谢