SQLServer2005中处理分页

最新推荐文章于 2018-07-03 00:32:21 发布

baimingjiang

最新推荐文章于 2018-07-03 00:32:21 发布

阅读量406

点赞数

分类专栏：数据库文章标签： sqlserver sql server asp.net join

本文链接：https://blog.csdn.net/baimingjiang/article/details/3974965

版权

数据库专栏收录该内容

2 篇文章 0 订阅

订阅专栏

--分页处理 SELECT * FROM ( SELECT isnc_Articles.ArticleID, isnc_Articles.AddedDate, isnc_Articles.AddedBy, isnc_Articles.CategoryID, isnc_Articles.Title, isnc_Articles.Abstract, isnc_Articles.Body, isnc_Articles.ReleaseDate, isnc_Articles.ExpireDate, isnc_Articles.Approved, isnc_Articles.Listed, isnc_Articles.CommentsEnabled, isnc_Articles.ViewCount, isnc_Categories.Title AS CategroyTitle, ROW_NUMBER() OVER (ORDER BY isnc_Articles.ReleaseDate DESC) AS RowNum FROM isnc_Articles INNER JOIN isnc_Categories ON isnc_Articles.CategoryID = isnc_Categories.CategoryID ) Articles WHERE Articles.RowNum BETWEEN (@PageIndex*@PageSize+1) AND ((@PageIndex+1)*@PageSize) ORDER BY ReleaseDate DESC

非常好用，在ASP.NET2.0网站建设全程解析中介绍的，拿来用啦^_^，在SQL Server2005中有个新函数ROW_NUMBER()函数，该函数返回一个从1开始的连续数列，排序查询的每一行都返回一个唯一值。在Select中添加个RowNum字段，然后选择在上界与下届之间的行返回即可。