USE pubs
GO

use pubs
-- 定义游标.
DECLARE authors_cursor SCROLL CURSOR FOR
SELECT au_lname, au_fname FROM authors
ORDER BY au_lname, au_fname

OPEN authors_cursor

-- 最后一条.
FETCH LAST FROM authors_cursor

-- 当前条的前一条,也就是上一条
FETCH PRIOR FROM authors_cursor



-- 相对于当前条的后一条,也就是下一条
FETCH RELATIVE 1 FROM authors_cursor


CLOSE authors_cursor
DEALLOCATE authors_cursor
GO