delteacher.sql

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

create TRIGGER   DelTeacher   ON  department
  
FOR   DELETE     
  
AS   
  
IF   @@RowCount   =   0   Return   
  
Declare   @ID  int  
  
Select    @ID=department_id   From   Deleted   
    
delete from teacher Where department_id   =   @ID