sql server分頁預存程序

標籤：

create proc [dbo].[messageMgr]    @pageSize int,    @pageIndex int,    @rcount bigint output--輸出查詢總記錄數asbegindeclare @startRowNum int;declare @endRowNum int;set @startRowNum=@pageSize*(@pageIndex - 1)+1;set @endRowNum=@pageIndex*@pageSize;    select * from (    SELECT ROW_NUMBER() over(order by a.short_message_time  desc) as number,*    FROM short_message_info as a) as a    where a.number between @startRowNum and @endRowNum;    select @rcount=count(number) from (    SELECT ROW_NUMBER() over(order by a.short_message_time  desc) as number,*    FROM short_message_info as a) as aend

 

sql server分頁預存程序