Question

如何创建触发器insert、update、delete

Answer 1

create trigger tr_a
on a
for insert,update,delere as
begin

IF EXISTS(SELECT 1 FROM inserted) AND NOT EXISTS(SELECT 1 FROM deleted)
BEGIN
-- 插入触发.
INSERT INTO B
SELECT
inserted.a
FROM
inserted;
END;

IF EXISTS(SELECT 1 FROM inserted) AND EXISTS(SELECT 1 FROM deleted)
BEGIN
-- 更新触发.
DELETE FROM B WHERE a in ( SELECT a FROM deleted);

INSERT INTO B
SELECT
inserted.a
FROM
inserted;
END;

IF NOT EXISTS(SELECT 1 FROM inserted) AND EXISTS(SELECT 1 FROM deleted)
BEGIN
-- 删除触发
DELETE FROM B WHERE a in ( SELECT a FROM deleted);

END;

end

Answer 2

触发器触发的条件有 insert,update,delete ,我想要一个例子 在一个表建立一create trigger tr_a on a for insert,update,delere as begin IF EXISTS

Answer 3

还是找一个软件高手给指点一下吧.