create trigger Delete_Student --创建一个触发器 on student instead of delete as declare @sno varchar(20) select @sno= sno from deleted delete from score where sno=@sno delete from student where sno=@sno go delete from Student where Sno=‘101‘ select *from Student select *from Score
sql-server数据库中利用触发器实现表与表之间的级联删除
原文：http://www.cnblogs.com/kangshuai/p/4621290.html