scroll.sql

来自「本程序中即有讲义」· SQL 代码 · 共 40 行

--声明 SCROLL 游标并使用其它 FETCH 选项
--下例创建一个 SCROLL 游标，使其通过 LAST、PRIOR、RELATIVE 和 ABSOLUTE 选项支持所有滚动能力。

USE pubs
GO

-- Execute the SELECT statement alone to show the 
-- full result set that is used by the cursor.
SELECT au_lname, au_fname FROM authors
ORDER BY au_lname, au_fname

-- Declare the cursor.
DECLARE authors_cursor  CURSOR SCROLL FOR -- FORWARD_ONLY
SELECT au_lname, au_fname FROM authors
ORDER BY au_lname, au_fname

OPEN authors_cursor

-- Fetch the last row in the cursor.

FETCH NEXT FROM authors_cursor
FETCH FIRST FROM authors_cursor

FETCH NEXT FROM authors_cursor
FETCH PRIOR FROM authors_cursor

-- Fetch the second row in the cursor.
FETCH ABSOLUTE 2 FROM authors_cursor

-- Fetch the row that is three rows after the current row.
FETCH RELATIVE 3 FROM authors_cursor

-- Fetch the row that is two rows prior to the current row.
FETCH last FROM authors_cursor

CLOSE authors_cursor
DEALLOCATE authors_cursor
GO