| 解决方案： |
----这个方法只限于只有人民币账户
----改账户定义的期初本位币余额
if exists (select 1 from sysobjects where id=object_id('fd_accdef') and type='u')
begin
alter table fd_accdef disable trigger fd_accdef_delete
alter table fd_accdef disable trigger fd_accdef_insert
alter table fd_accdef disable trigger fd_accdef_update
UPDATE fd_accdef SET qcye_natural_mny = mb
alter table fd_accdef enable trigger fd_accdef_delete
alter table fd_accdef enable trigger fd_accdef_insert
alter table fd_accdef enable trigger fd_accdef_update
end
go
---备份
select * into fd_accbalnew from fd_accbal
---- 更改余额表的本位币数值
update fd_accbal
set natural_rcv_mny = rcv_mny , natural_rcv_booked_mny = rcv_booked_mny,
natural_pay_mny = pay_mny , natural_pay_booked_mny = pay_booked_mny,
natural_bal_mny =bal_mny,natural_bal_booked_mny =bal_booked_mny |