sql分页存储过程

--编写存储过程，查询表中的总数据，及当前页的数据--pageindex,pagesizecreate proc GetPageList@pageIndex int,@pageSize  int,@rowCount int outputasbegin  SET NOCOUNT ON select @rowcount=COUNT(*)from StudentInfo where isDelete=0 select * from  (select *,ROW_NUMBER() over(order by sid asc) as rowIndex from StudentInfo where IsDelete =0)as t1 where rowIndex between (@pageIndex-1)*@pageSize and @pageSize*@pageIndexend

执行存储过程

declare @temp intexec GetPageList 1,5,@temp outputprint @temp

结果