将numeric转换为数据类型numeric时出现算术溢出错误
sqlcode:
T1 name price qty money([price]*[qty])
aaa 1000 100 100000
bbb 1111 100 111100
ccc 2222 100 222200
View xx
select name, sum(money)as ttcost from T1 group by name
自动创建好T1、插入T1所有记录到old_T1,清空T1
创建old_view xx
为了继承T1的数据:
insert into T1(name,price)
select '库存',sublogistics.* from (select name,ttcost from logistics) as sublogistics
where sublogistics.ttqty<>0
但sql提示numeric转换为类型numeric时发生算术溢出错误……
视图的money长度永远>price的,那么视图也是这样的嘛?ttcost如何才能写入到price中?求解