例2、创建一触发器,要求当插入、更新、删除 StuCou表的选课记录时,能更新 Course表中相应 的报名人数 USE XK CREATE TRigGer SetWillNum on Stucou FOR NSERT. UPDATE. DELETE AS UPDATE Course set WillNum=WillNum+1 WHERE CouNo=(SELECT CouNo FROM INSERTED UPDATE Course set WillNum=Willnum-1 WHERE CouNo(SELECT CouNo FROM DELETED)例2、创建一触发器，要求当插入、更新、删除 StuCou表的选课记录时，能更新Course表中相应 的报名人数 USE Xk CREATE TRIGGER SetWillNum ON StuCou FOR INSERT, UPDATE, DELETE AS UPDATE Course SET WillNum=WillNum+1 WHERE CouNo=(SELECT CouNo FROM INSERTED) UPDATE Course SET WillNum=WillNum-1 WHERE CouNo=(SELECT CouNo FROM DELETED)