[计算机软件及应用]第7章 存储过程和触发器.pptVIP

Update触发器 create trigger tr_CourseList_Update on select_courselist for update as if @@rowcount=0 return declare @CourseName varchar(50) declare @temp int declare Course_cur cursor for select CourseName from deleted open course_cur fetch next from course_cur into @coursename while @@fetch_status=0 begin update student_count set studentcount=studentcount-1 where coursename=@coursename fetch next from course_cur into @coursename end close course_cur deallocate course_cur Update触发器（续） declare Course_cur1 cursor for select CourseName from inserted open course_cur1 f