[已解决问题] 触发器中关于集联删的问题，Help Me!
提问时间: 2008-03-07 13:45
悬赏分：20 浏览:282 次
说明:studnet 表中外键CourseID为Course表中的主键，当删除Course表中的CourseID时，对应Studnet表中的也被删除。
下面这个有错误，我觉的是违反了主外键的一些规则，该怎么写啊？
Create Trigger Delete_ID
On Course
for delete
as
DECLARE @CourseID int
select @CourseID = CourseID FROM Course deleted
IF EXISTS (Select * from Student where CourseID = @CourseID)
begin
delete From Student where Student.CourseID=deleted.CourseID
end
最佳答案
Create Trigger Delete_ID
On Course
before delete
as
delete From Student where Student.CourseID in
(select id from deleted)
提问者对于答案的评价：xiexie
On Course
before delete
as
delete From Student where Student.CourseID in
(select id from deleted)
2008/3/22 23:52:43
回答者：重典
提问者对于答案的评价：xiexie
评论