Mikel
问题：
执行存储过程报：
将 numeric 转换为数据类型 numeric 时出现算术溢出错误。
问题原因：
存储过程中创建临时表时，临时表的字段类型长度小于后续更新的值的长度导致
转换异常
解决办法：
创建临时表时利用cast将字段类型转换为长度符合插入值的类型
代码如下：
SELECT Identifier,Stock_State,Supplier_ID,Buyer_ID,Goods_ID,Unit_ID,Tax_ID,cast(0 as money) as Start_Amount,cast(0 as money) as Into_Amount,cast(0 as money) as Outlay_Amount,Stock_Money as End_Amount,Into_Price,Tax_Money,@Start_Date as Start_Date,@End_Date as End_Date,cast(0 as decimal(18,4)) as Start_Stock,cast(0 as decimal(18,4)) as Into_Stock,cast(0 as decimal(18,4)) as Outlay_Stock,Total_Stock as End_Stock,Tax_Value,Batch_Code,Supplier,Supplier_Secrecy,Buyer,Goods_Name,Physical,Chemistry,Detail_Params,Stock_Unit,Tax_RateINTO #temp_AccountsInventoryFROM Stock_Details |
