在库存产品信息中见插入触发器
UPDATE 帐户信息 SET 累计=ISNULL(累计,0)+ A.SL
FROM (SELECT SUM(1) SL,会员ID FROM INSERTED GROUP BY 会员ID ) A
WHERE 帐户信息.会员ID =A.会员ID
UPDATE 帐户信息 SET 累计=ISNULL(累计,0)+ A.SL
FROM (SELECT SUM(1) SL,会员ID FROM INSERTED GROUP BY 会员ID ) A
WHERE 帐户信息.会员ID =A.会员ID
for update
as
update 会员表 set 条目数=(select count(1) from 库存表 where 产品id=会员表.产品id) where 产品id in (select 产品id from inserted)
go
insert 表 values (1)
go
CREATE TRIGGER 名 ON 表
FOR UPDATE
AS
select a 更新前被删除的数据 from deleted
select a 更新后被插入的数据 from inserted
go
------------测试:
update 表 set a=3