delsubject.sql

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

create TRIGGER   DelScore   ON  Subject
  
FOR   DELETE
  
AS   
  
IF   @@RowCount   =   0   Return   
  
Declare   @ID  int  
  
Select    @ID=Subject_id   From   Deleted   
    
delete from score Where Subject_id   =   @ID