It is known to all of us that there isn't any one-step
paging SQL statement in SQL Server.
On the net, I found several solutions for resultset
paging with TSQL.
1. Select ordered records into a temp table which has
an indentity column (id), and then Select between
id>a and id<=b from that temp table. Since a temp
table is used, CONSIDERABLE IO OPERATIONS might
occur when the resultset is huge.
2. Select with cursor. Since using cursor can Fetch
only one row at a time, we might like to Insert
what is fetched into a table variable and then