create trigger T_P on 学生表 for delete as declare @学号 intselect @学号=deleted.学号from deletedprint '准备级联删除表二中的学生信息!'delete 成绩表where 成绩表.学号=@学号