摘要： DECLAREmCursorcursor/*声明游标，默认为FORWARD_ONLY游标*/FORselectBH,ScorefromStudent/*打开游标*/openmCursorFETCHNEXTfrommCursor/*读取第1行数据*/WHILE@@FETCH_STATUS=0/*用WHILE循环控制游标活动*/BEGINFETCHNEXTfrommCursor/*在循环体内将读取其余行数据*/ENDCLOSEmCursor/*关闭游标*/DEALLOCATEmCursor/*删除游标*/ 阅读全文