Code CreatePROCEDURE dbo.sp_Pager
( @PageSizeint, -- 一页显示记录数 @PageIndexint-- 当前页码(从1开始) ) as declare@strSQLnvarchar(1000) -- 主语句 if (@PageIndex=1) begin set@strSQL="selecttop "+str(@Pagesize)+" *from T_ServiceInfo orderby fld_ID desc" end elseif(@PageIndex>1) begin set@strSQL="selecttop " +str(@PageSize) + " *from T_ServiceInfo where ( fld_ID <
(selectmin (fld_ID) from (selecttop "+str(@PageSize*(@PageIndex-1)) + " fld_ID from T_ServiceInfo order by fld_ID desc) as T )) orderby fld_ID desc" end exec(@strSQL) GO
Sql Server 2005
posted on
2009-03-03 14:06Robin99
阅读(112)
评论(0)
收藏举报