发一个触发器----数据删除copy到备份表

create TRIGGER Delete_Class_Info
ON Class_Info
AFTER DELETE
AS
INSERT INTO AddressListBack.dbo.Class_Info
SELECT * FROM deleted
PRINT 'DELETE '


create TRIGGER Update_Class_Info
ON Class_Info
AFTER update
AS
INSERT INTO AddressListBack.dbo.Class_Info
SELECT * FROM inserted
PRINT 'update '


create TRIGGER Insert_Class_Info
ON Class_Info
AFTER insert
AS
INSERT INTO AddressListBack.dbo.Class_Info
SELECT * FROM inserted

PRINT 'insert '

 

 

inserted表：用来存储INSERT和UPDATE语句所影响的行的副本。意思就是在 inserted表中临时保存了被插入或被更新后的记录行。在执行 INSERT 或UPDATE 语句时，新加行被同时添加到inserted表和触发器表中。因此，可以从inserted表检查插入的数据是否满足需求，如不满足则回滚撤消操 (cāo)作。

deleted表：用来存储DELETE和UPDATE语句所影响行的副本。意思是在delete表中临时保存了被删除或被更新前的记录行。在执行 DELETE 或 UPDATE 语句时，行从触发器表中删除，并传到deleted表中。所以可以从deleted表中检查删除的数据行是否能删除。