简单触发器有关问题。求大神

简单触发器问题。求大神
创建一触发器，当修改课程编号时，成绩表中的课程编号也要做相应修改。
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 cno=@InsertCno where cno=@DeleteCnoENDUPDATE course SET cno ='002' WHERE cno='001'