INSERT INTO @temp SELECT TOP @PageSize PK FROM ( SELECT TOP(@StartRow + @PageSize ) PK, SortColumn /* If sorting column is defferent from the PK,SortColumn must be fetched as well,otherwise just the PK is necessary */
ORDER BY SortColumn /* defaultorder–typicallyASC */ )
ORDER BY SortColumn /* reversed default order–typicallyDESC */
SELECT FROM Table JOIN @Temp temp ON Table .PK= temp .PK ORDER BY SortColumn /* defaultorder */
SELECT FROM Table WHERE PK IN( SELECT TOP @PageSize PK FROM Table WHERE PK NOT IN ( SELECT TOP @StartRow PK FROM Table ORDER BY SortColumn) ORDER BY SortColumn) ORDER BY SortColumn 游标