create procedure pro_User(
@pageIndex int,
@pageSize int
)
as
declare @startRow int, @endRow int
set @startRow = (@pageIndex - 1) * @pageSize +1
set @endRow = @startRow + @pageSize -1
select * from (
select *, row_number() over (order by UserID asc) as number from VW_UserInfo
) t
where t.number between @startRow and @endRow;
看不懂什么意思
看代码就是分页后的开始行和结束行,通过pageIndex(当前页)和PageSize(页大小)计算得来的