DECLARE @pageSize INT ;

DECLARE @pageIndex INT ;

SET @pageSize = ５

SET @pageIndex =２ ;

 --第二页，每页显示５条数据

SELECT  *

FROM    ( SELECT    ROW_NUMBER() OVER ( ORDER BY CreateDate ASC ) AS 'rowNumber' ,

                    *

          FROM      dbo.Task_Info

        ) AS temp

WHERE   rowNumber BETWEEN ( ( ( @pageIndex -  ) * @pageSize ) +  )

                  AND     ( @pageIndex * @pageSize )