declare @CurrPage int --当前页
declare @PageSize int --每页显示记录数
set @CurrPage=2
set @PageSize=15
select * from
(
select top (@PageSize) * from
(
select top (@PageSize * @CurrPage) * from [MF_Pet].[dbo].[Blog_UserArticle] order by ArticleId desc
) as Temp1 order by Temp1.ArticleId asc
) as Temp order by Temp.ArticleId desc
declare @PageSize int --每页显示记录数
set @CurrPage=2
set @PageSize=15
select * from
(
select top (@PageSize) * from
(
select top (@PageSize * @CurrPage) * from [MF_Pet].[dbo].[Blog_UserArticle] order by ArticleId desc
) as Temp1 order by Temp1.ArticleId asc
) as Temp order by Temp.ArticleId desc