DECLARE @SUMCOUNT INT,@SQL NVARCHAR(4000)
SET @SQL=N'SELECT @SUMCOUNT=SUM(COUNTS) FROM #TEMP'
EXEC SP_EXECUTESQL @SQL,N'@SUMCOUNT INT OUT',@SUMCOUNT OUTupdate #temp set counts=@SUMCOUNT where code='CC'
SELECT * FROM #temp
SET @SQL=N'SELECT @SUMCOUNT=SUM(COUNTS) FROM #TEMP'
EXEC SP_EXECUTESQL @SQL,N'@SUMCOUNT INT OUT',@SUMCOUNT OUTupdate #temp set counts=@SUMCOUNT where code='CC'
SELECT * FROM #temp
中的@SUMCOUNT改成cast(@SUMCOUNT as varchar(20))