分页的存储过程

1 创建分页的存储过程 

create proc  GetPageList 
	@pageIndex int ,
	@pageSize int,
	@rowCount int output
as
begin
	set nocount on
	select @rowCount=count(*) from student
	select * from
	(select *,row_number() over (order by sid) as row from student) as t
	where row between (@pageIndex-1)*@pageSize+1 and @pageIndex*@pageSize
end

2 调用存储过程

declare @count int
exec GetPageList 1, 2, @count output
print @count

3 获得的数据在结果选项页

返回的rowCount在消息选项页