資料庫游標數怎麼填

㈠ 鏁版嵁搴撴父鏍囨庝箞鍐

DECLARE
娓告爣鍚
CURSOR
FOR
SELECT璇鍙
OPEN
娓告爣鍚
FETCH
娓告爣鍚
INTO
@鍙橀噺1,@鍙橀噺2,...,@鍙橀噺n--(鍙橀噺涓鏁拌佷笌SELECT璇鍙ョ粨鏋滅殑涓鏁頒竴鑷)
WHILE
(@@FETCH_STATUS
=
0)
BEGIN
--澶勭悊浠ｇ爜
FETCH
娓告爣鍚
INTO
@鍙橀噺1,@鍙橀噺2,...,@鍙橀噺n
END
CLOSE
娓告爣鍚
DEALLOCATE
娓告爣鍚
END