delscore.sql

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

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