这些语句为什么不能执行?
SELECT @code = 1
SELECT @areaLastYear = 1
SELECT @areaCurrentYear = 1
SELECT @changeRate =1
SELECT @SQLInsertResult = "INSERT "+ @resultTable + "(TypeID,AreaLY,PercentLY,AreaCY,PercentCY,ChangeRate) VALUES("
+ @code + "," + @areaLastYear + "," + 0.00 + "," +@areaCurrentYear+ "," + 0.00 + "," + @changeRate + ")"
EXEC(@SQLInsertResult)
服务器: 消息 245,级别 16,状态 1,行 96
将 nvarchar 值 'INSERT CZ_Result(TypeID,AreaLY,PercentLY,AreaCY,PercentCY,ChangeRate) VALUES(' 转换为数据类型为 int 的列时发生语法错误。