delclass.sql

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

 

/******辅导员老师被删除时，删除其所管理的所有班级*****/
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