建立一个触发器,当向sc表中添加数据时,如果添加的数据与student表中的数据不匹配(没有对应的学号),则将此数据删除。
create trigger SC_sc on SC
for insert
as
begin
declare @bh char(9)
select @bh=INSERTED.sno from INSERTED
if not exists(select sno from student where student.sno=@bh)
delete from SC where sno=@bh
end