第5章T-SQL程序设计.ppt

2、 delete 触发器 例：建立delete 触发器tric_del ,该触发器防止删除学生表S中IS系的学生记录 CREATE TRIGGER trig_del ON S after delete AS Begin if exists(select * from deleted where sdept=is) begin raiserror(不能删除该系的记录,16,2) rollback end End UPDATE Statement to a table with an UPDATE Trigger Defined UPDATE member SET member_no = 10021 WHERE member_no = 1234 UPDATE Statement logged as INSERT and DELETE Statements member member_no lastname firstname middleinitial photograph 10020 10021 10022 10023 Anderson Barr Barr Anderson Andrew Andrew Bill Bill A R NULL B ~~~ ~~~ ~~~ 1234 Barr Andrew R ~~~