Question

对学生表创建触发器，一旦删除某个学生，则相应在选课表中该学生的选课信息也将同时删除。

求代码

Answer 1

create trigger tri_student
on [学生表]
after delete
as
delete from [选课表]
where 学生ID in
(select 学生ID from deleted)

Answer 2

create trigger tri_delete
on S
after delete
as
begin
declare @sno int
select @sno=sno from deleted
delete from xk where xk.sno=@sno
end
其中xk是选课表，S是学生表

Answer 3

create trigger test
on 学生表
after delete
if exists(select sno from deleted )
delete 选课表
where sno in
(select 学生ID from deleted)