几种常用存储过程分页方法 TopN方法 select Top(@PageSize) from TableName where ID Not IN (Select Top ((@PageIndex-1)*@PageSize) ID from Table Name where …. order by … ) where …. order by … 临时表 代码如下:declare @indextable table(id int identity(1,1),nid int,PostUserName nvarchar(50)) declare @PageLowerBound int declare
