DECLARE @code int
DECLARE @areaLastYear float
DECLARE @areaCurrentYear float
DECLARE @changeRate float
DECLARE @areaLastYear float
DECLARE @areaCurrentYear float
DECLARE @changeRate float
+ @code + "," + @areaLastYear + "," + 0.00 + "," +@areaCurrentYear+ "," + 0.00 + "," + @changeRate + ")"
这里面有很多的强制类型转换,不象VB用&连接可以将数字转换为字符
SELECT @SQLInsertResult = 'INSERT '+ @resultTable + '(TypeID,AreaLY,PercentLY,AreaCY,PercentCY,ChangeRate) VALUES('
+cast( @code as varchar(10))+ ',' + cast(@areaLastYear as varchar(10)) + ',0.00 ,' +cast(@areaCurrentYear as varchar(10))+ ',0.00 ,' + cast(@changeRate as varchar(10)) + ')'
将数据类型 varchar 转换为 numeric 时出错。
用法:CONVERT(新类型,要转换的字段或变量)
[Microsoft][ODBC SQL Server Driver][SQL Server]将 nvarchar 转换为数据类型 numeric 时发生算术溢出错误。@RETURN_VALUE = N/A