Question

创建一个触发器，当删除一个学生信息时，删除成绩表中所有有关该学生的信息。

Answer 1

Student表：StudentID,StudentName
StudentCJ表：StudentID,StudentCJ
触发器：
CREATE TRIGGER [Delete_student] ON [dbo].[Student]
FOR DELETE
AS
begin
declare @StudentID int
select @StudentID=StudentID from deleted
delete from StudentCJ where StudentID=@StudentID
end
有问题可以追问或Hi我。

Answer 2

语句

create trigger del on 学生表
for delete
as
begin
delete from 成绩表
where studentid in (select studentid from deteled)
end

Answer 3

create or replace trigger tr1
before delete on XSB
for each row
begin
delete from CJB where CJB.xh=:old.xh;
end;
/