SqlServer分页方式

第一种方式：

用ROW_NUMBER() OVER 

例：

 select * from 
 (select *,ROW_NUMBER() over (order by ID) rowindex from TableName) as A
 where rowindex > pagesize *(pageIndex -1)  and rowindex <= pagesize * pageIndex

第二种方式

例：

create proc assetsRegister_Summary 
@PageSize int,
@PageIndex int
as
begin
if(@PageIndex = 1)
begin
select top (@PageSize) *
from TableName
end
else 
begin
select top (@PageSize)*
from TableName
where ID> 
(
select max(ID) as sqid from (select top (@PageSize *(@PageIndex -1))
ID from TableName order by ID) as sqTemp
)
end
end

执行存储过程：exec assetsRegister_Summary 8,5