delclass.sql

思燕大学成绩查询系统 具有很高的参考价值 大家可以看一看

 

/******辅导员老师被删除时，删除其所管理的所有班级*****/
create TRIGGER DelClass ON Teacher   
  
FOR DELETE     
  
AS   
  
IF @@RowCount=0 Return   
  
Declare @ID int  
  
Select @ID=teacher_id From Deleted   
   
delete from class Where teacher_id = @ID