asp.net分页小工具

一个关于asp.net的分页小工具。createPROCEDUREHistoryRecordPage@PAGESIZEint,@PAGEINDEXintASDECLARE@STRATINT,@ENDINTSET@STRAT=@PAGESIZE*(@PAGEINDEX-1)SET@END=@STRAT+@PAGESIZESELECT*FROM(SELECTROW_NUMBER()OVER(ORDERBYa.SendDateasc)RID,a.ID,a.SendDate,b.name,c.MessageContentFROM