假设库存表是A,退货表是B，库存表中的数量的那一列是kucun，退货表中的退货数量的列名是 tuihuo ，那么触发器这样写CREATE TRIGGER test ON BFOR INSERT ASUPDATE A SET kucun = 库存+（select tuihuo FROM inserted） WHERE 条件...
CREATE TRIGGER [TRIGGER_NAME] ON [dbo].[alinshi] FOR INSERT AS begin declare @sh int select @sh=a from inserted update abcd set c=c+@sh where abc in (select zf from ins...
