主题：sqlserverl触发器

create trigger trig_update
on B
after update
as
begin
    declare @stuCount float;
    select @stuCount=sum(应收金额) from B where 是否含piao = 1 and ID = inserted.ID;

    update A set 含piao应收=@stuCount where ID = inserted.ID;

end