这个分页查询的startrow和endrow干什么用的

Question

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;
看不懂什么意思

Answer 1

看代码就是分页后的开始行和结束行，通过pageIndex(当前页)和PageSize（页大小）计算得来的