Begin TransactionDeclare Mycursor Cursor Forselect Stu_no, Score, Words from Belind_console Where College_Id = @ college_idfor Update of Score
Open mycursorwhile (0 = 0) Begin fetch next from mycursor INTO @ stu_no, @ hhg, @ Words if @@ fetch_status <> 0 Break Else Begin - DO SOMTING EndendClose mycursordeallocate MyCursor