create trigger tri_A on A after update as update B set XM=inserted.XM from inserted,B where B.DW=inserted.DW
我按照这样写了,但更改A表的XM内容后,B表的XM字段内容还是没变,请教怎么回事?
我是这样写的 CREATE trigger TR_hsdw_yhzh_update on hsdwyhzh after update as update bankaccount set cbank02=inserted.yhzh01 from inserted,bankaccount where bankaccount.chsdw01=inserted.chsdw01
update B set XM=inserted.XM from inserted,B where B.DW=inserted.DW
CREATE trigger TR_hsdw_yhzh_update
on hsdwyhzh
after update
as
update bankaccount set cbank02=inserted.yhzh01 from inserted,bankaccount
where bankaccount.chsdw01=inserted.chsdw01