delteacher.sql

来自「eayanQuery思燕大学成绩查询系统 版本 V1.6」· SQL 代码 · 共 14 行

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