将 numeric 转换为数据类型 numeric 时出现算术溢出错误。

[小野马1209]

执行以下更新脚本报错，求解：

declare @temp  table (AddTotalCostAmt numeric(19,9),CU_AddTotalBuildAmt numeric(19,9),CU_PredictCostRate numeric(9,7))

insert into @temp select 2035360.000000000,9600.000000000,0

select * from @temp

update @temp set CU_PredictCostRate=ROUND(AddTotalCostAmt/CU_AddTotalBuildAmt,4) 

[二月十六]

把CU_PredictCostRate 生成明 numeric(19,7)

declare @temp  table (AddTotalCostAmt numeric(19,9),CU_AddTotalBuildAmt numeric(19,9),CU_PredictCostRate numeric(19,7))
 
insert into @temp select 2035360.000000000,9600.000000000,0

 
update @temp set CU_PredictCostRate=ROUND(AddTotalCostAmt/CU_AddTotalBuildAmt,4) 

[小野马1209]

引用 1 楼 sinat_28984567 的回复:

把CU_PredictCostRate 生成明 numeric(19,7)

declare @temp  table (AddTotalCostAmt numeric(19,9),CU_AddTotalBuildAmt numeric(19,9),CU_PredictCostRate numeric(19,7))
 
insert into @temp select 2035360.000000000,9600.000000000,0

 
update @temp set CU_PredictCostRate=ROUND(AddTotalCostAmt/CU_AddTotalBuildAmt,4) 

是因为这个比率字段小数位数太少是吗

[二月十六]

引用 2 楼 kaijie_wu1209 的回复:

[quote=引用 1 楼 sinat_28984567 的回复:]
把CU_PredictCostRate 生成明 numeric(19,7)

declare @temp  table (AddTotalCostAmt numeric(19,9),CU_AddTotalBuildAmt numeric(19,9),CU_PredictCostRate numeric(19,7))
 
insert into @temp select 2035360.000000000,9600.000000000,0

 
update @temp set CU_PredictCostRate=ROUND(AddTotalCostAmt/CU_AddTotalBuildAmt,4) 

是因为这个比率字段小数位数太少是吗[/quote]
shi