创建一触发器，当修改课程编号时，成绩表中的课程编号也要做相应修改。
score course 主键cno
------解决方案--------------------
- SQL code
CREATE table score(cno varchar(10))CREATE table course(cno varchar(10))INSERT INTO score SELECT '001'INSERT INTO course SELECT '001'CREATE TRIGGER tr_Update ON course FOR UPDATE ASBEGIN declare @DeleteCno int declare @InsertCno int select @DeleteCno=cno from deleted select @InsertCno=cno from inserted update score set [email protected] where [email protected]ENDUPDATE course SET cno ='002' WHERE cno='001'