Question

在课程表上建立触发器'tr_delete'当在课程表中删除一条记录后，能自动将'教师任课'表与‘选课’表，

相应课程记录删除。课程表（课程号，课程名，学时数，学分）教师任课表（教师编号，课程号…）学生选课表（学号，课程号……）

Answer 1

create trigger tr_delete on 课程表
for delete
as
begin
delete t1.*
from 教师任课表 t1,
deleted t2
where t1.课程号=t2.课程号

delete t1.*
from 学生选课表 t1,
deleted t2
where t1.课程号=t2.课程号
end

Answer 2

你用的那个数据库啊？

追问

就是 SQL sever2005