create trigger tr_1 on 表B
for update
as
update 表A set fmoney = B.fmoney from inserted B
where B.Fname = 表A.fname
for update
as
update 表A set fmoney = B.fmoney from inserted B
where B.Fname = 表A.fname
set fmoney=b.fmoney
from b
where a.fname=b.fname
and a.fmodel=b.fmodel小心,你没有说明两表的连接方法,我猜的,错了别怪我
set fmoney=aa.fmoney
from B aa
where A.Fname=aa.Fname
還是都可以?update 表A set Fmoney=表B.FMoney from 表B,表A where 表A.Fname=表B.Fname