begin transaction declare mycursor Cursor for select stu_no,score,words from belind_console where college_id=@college_id for update of score
open mycursor while(0=0) begin fetch next from mycursor into @stu_no,@hhg,@words if @@fetch_status<>0 break else begin --do someting end end close mycursor deallocate mycursor

|