Question

SQL Server 2005 高手请进。触发器问题。

创建一个名为“trig_4”的触发器，当向“学生”表删除记录时， --该触发器自动删除成绩表中与之相关的

Answer 1

create trigger tri_after_del on 学生表昌早 after delete
as
begin
delete from 成绩耐带雀表行前 where StuNo in(select StuNo from deleted)
end

追问

不行哟！

追答

你怎么写的 贴出来

追问

create trigger trig_4
on 学生
for delete
as
begin
delete from 成绩 where 学生 in(select 学生 from deleted)
end

追答

create trigger trig_4
on 学生
after delete
as
begin
delete from 成绩 where 学号字段名 in(select 学号字段名 from deleted)
end

Answer 2

create trigger tri_after_del on 学生睁唯表 after delete
as
begin
delete from 成绩表 where StuNo =:old.学悉滚培备改生表Id
end