Open up a query window for the pubs database, and execute the
following. This will return the 10 records starting at row 21. I
believe these stored procs are provided by ODBC. Seems to perform
well.

declare cursor int
exec sp_cursoropen cursor out, 'SELECT * FROM pubs.dbo.authors ORDER
BY au_lname'
--fetchtype
--1 - fetch first
--2 - fetch next
--4 - fetch prev
--8 - fetch random
--16 - fetch relative
--32 - fetch last
--exec sp_cursorfetch cursor,2,0,10

exec sp_cursorfetch cursor,16 /*FETCH RELATIVE*/,21 /*START ROW*/,10
/* PAGESIZE */

exec sp_cursorclose cursor