--思路:利用内置函数ROW_NUMBER()OVER(),将发布时间作为排序的依据,重新计算每列的行号;
然后通过指定:页号,每页显示的记录数,两个参数进行查询;
ALTER PROCEDURE dbo.tbh_Articles_GetArticles
(
@PageIndex int,
@PageSize int
)
AS
SELECT * FROM
(
SELECT tbh_Articles.ReleaseDate, ROW_NUMBER()OVER (ORDER BY ReleaseDate DESC) AS 文章编号
FROM tbh_Articles
) Articles
WHERE Articles.文章编号 BETWEEN (@PageIndex*@PageSize+1) AND ((@PageIndex+@PageSize)*5)
ORDER BY ReleaseDate DESC