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在消息选项页