delsubject.sql

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

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