先创建一个函数getcredit()，该函数的功能是根据课程号得到该门课的学分。然后再建触发器。create function getcredit(@cno char)returns intasbegindelclare @credit intselect @credit=Ccredit from Course1 where Cno=@cnoreturn @credit end然后建立触发器：create trigger trg on SC1 for insert,updateas.....往下不会了，我想应该用嵌套触发器吧，这个没学过，不好意思了
CREATE TRIGGERsc1triON sc1for insert,updateASdelclare @credit ,@cno int select @cno=cno from sc1 s inner join inserted i ons.cno =i.cnoselect @credit=Ccredit from C
