删除触发器语句sql 关于SQL Server触发器instead of delete使用问题？

关于SQL Server触发器instead of delete使用问题？create trigger tri_instead_delon studentinstead of deleteasbegi

关于SQL Server触发器instead of delete使用问题？

create trigger tri_instead_delon studentinstead of deleteasbegin declare @courseId varchar(50) --定义编号变量。 --在deleted表中查询要删除的编号 select @courseId=stu_idfrom deleted delete from score where stu_id=@courseId delete from student where stu_id=@courseId --其中就要通过deleted表来查询要删除的编号endINSTEADOF触发器：它在执行INSERT、UPDATE、DELETE语句操作之前执行触发器本身所定义的操作。而INSTEADOF触发器是可以定义在视图上的