两张表a表和b表,结构完全一样。当a表中有数据被删除或插入或字段被更改时,b表也同样,功能就是相当于将a表数据备份到b表,谢谢! ------------------------------------------------------- CREATE TRIGGER tri_a ON a FOR INSERT,UPDATE,DELETE AS IF EXISTS (SELECT * FROM deleted) BEGIN DELETE FROM b WHERE .....--(所有栏位与deleted表相等的条件) END IF EXISTS (SELECT * FROM inserted) BEGIN INSERT INTO b SELECT * FROM inserted END
-------------------------------------------------------
CREATE TRIGGER tri_a ON a
FOR INSERT,UPDATE,DELETE
AS
IF EXISTS (SELECT * FROM deleted)
BEGIN
DELETE FROM b WHERE .....--(所有栏位与deleted表相等的条件)
END
IF EXISTS (SELECT * FROM inserted)
BEGIN
INSERT INTO b SELECT * FROM inserted
END