ASP.Net 学习点滴---存储过程分页

ALTER PROCEDURE dbo.PagingPost
 (
 @QueryWhere nvarchar(1000),
 @SortExpression nvarchar(50),
 @StartRowIndex int,
 @MaximumRows int
 )
AS
 exec ('WITH PostOrders AS
                    (
                     SELECT *, ROW_NUMBER() OVER(ORDER BY ' + @SortExpression + ') AS ROW_NUMBER
                     FROM [vPost] ' + @QueryWhere +'
                    )
                    SELECT * FROM PostOrders
                    WHERE ROW_NUMBER > ' + @StartRowIndex +' AND ROW_NUMBER <= ' +
                    @StartRowIndex + @MaximumRows
          )
 RETURN

一切都是因为有了ROW_NUMBER