例1、声明一游标,从 Course表中检索所有记录 ■ USE XK dEclare Crs Course CURSOR FOR SELECt FROM Course ORDER BY Couno ■ oPen Crs course FETCH NEXt FROm CrsCourse uPdatE Course set LimitNum=22 WHERE CURRENT OF Crs Course ClOSE Crs Course DEALLOCATE Crs Course例1、声明一游标，从Course表中检索所有记录。 USE Xk DECLARE CrsCourse CURSOR FOR SELECT * FROM Course ORDER BY CouNo OPEN CrsCourse FETCH NEXT FROM CrsCourse UPDATE Course SET LimitNum=22 WHERE CURRENT OF CrsCourse CLOSE CrsCourse DEALLOCATE CrsCourse