第八章 数据库编程.ppt

例 当删除表student中的记录时，自动删除表sc中对应学号的记录。 CREATE TRIGGER students.tr_student_sc_delete ON students.student AFTER DELETE AS BEGIN DECLARE @sno char(10) Select @sno=deleted.sno from deleted Delete students.sc where sno=@sno END INSTEAD OF触发器实例 在student表删除学生记录的同时删除学生的选课记录 Create TRIGGER [students].[tr_student_instead] ON [students].[student] instead of DELETE AS BEGIN delete students.sc where sno in ( select deleted.sno from deleted ) delete students.student where sno in ( select deleted.sno from deleted ) END DML触发器执行过程 INSTEAD OF触发器 AF