test_for_trigger.sql

一个经典的东东

--测试class与student之间的级联外键约束
select * from class
select * from student
delete class where classid=8
insert into student(studentno,studentname,gender,birthday,classid,remark) values('1111','David','0',getdate(),8,'')
--测试class与course之间的级联外键约束
select * from class
select * from course
delete class where classid=3
insert into course(classid,subjectid,begindate,finishdate,remark) values(9,10,getdate(),getdate(),'')
--测试course自身的插入与更新约束(即：不能插入或更新数据与当前classid和subjecid相同的数据)
select * from course
insert into course(classid,subjectid,begindate,finishdate,remark) values(1,2,getdate(),getdate(),'')
update course set classid=1,subjectid=3 where courseid=17
--测试student与score之间的级联外键约束
select * from student
select * from score
delete student where studentid=3
insert into score(courseid,studentid,score) values(18,23,100)
--测试score自身的插入与更新约束（即：不能插入或更新数据与当前courseid和studentid相同的数据）
select * from score
insert into score(courseid,studentid,score) values(17,6,100)
update score set courseid=17,studentid=6 where scoreid=14
--测试score与course之间的级联外键约束
select * from score
select * from course
delete course where courseid=18
insert into score(courseid,studentid,score) values(18,8,100)
--测试subject与course之间的级联外键约束
select * from subject
select * from course
delete subject where subjectid=2
insert into course(classid,subjectid,begindate,finishdate,remark) values(1,2,getdate(),getdate(),'')