About the use of the cursor

xiaoxiao2021-03-06  65

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

转载请注明原文地址:https://www.9cbs.com/read-119910.html

New Post(0)