文章出處

create proc [dbo].[messageMgr]
    @pageSize int,
    @pageIndex int,
    @rcount bigint output--輸出查詢總記錄數
as
begin
declare @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 a
end

 


文章列表



Avast logo

Avast 防毒軟體已檢查此封電子郵件的病毒。
www.avast.com


全站熱搜
創作者介紹
創作者 大師兄 的頭像
大師兄

IT工程師數位筆記本

大師兄 發表在 痞客邦 留言(0) 人氣()

E-mail轉寄