博客园-纯净天空-最新评论http://slightboy.cnblogs.com/CommentsRSS.aspx沉迷于技术 痴情于开发zh-cnThu, 14 Apr 2011 06:01:08 GMTThu, 14 Apr 2011 06:01:08 GMTcnblogsre: 通用分页存储过程http://www.cnblogs.com/slightboy/archive/2008/11/05/228874.html#1361402slightboyslightboyTue, 04 Nov 2008 18:47:38 GMThttp://www.cnblogs.com/slightboy/archive/2008/11/05/228874.html#1361402另外 row_number 我在这里有说明的
http://www.cnblogs.com/slightboy/archive/2008/05/21/1204281.html

slightboy 2008-11-05 02:47 发表评论
]]>re: 通用分页存储过程http://www.cnblogs.com/slightboy/archive/2008/11/02/228874.html#1358680爱上爱上Sun, 02 Nov 2008 07:11:44 GMThttp://www.cnblogs.com/slightboy/archive/2008/11/02/228874.html#1358680给你个好一些的
CREATE PROCEDURE P_GetPagedOrders2005
@startIndex INT, // 第几页
@pageSize INT //一页显示几条数据

AS

with orderlist as(
select row_number() over(order by freight) as rownumber, orderid,customerid from orders)
select orderid,customerid from orderlist
where rownumber between @startindex and @startindex+@pagesize-1
go

爱上 2008-11-02 15:11 发表评论
]]>re: 《Oracle Developer Suite 10g》(Oracle Developer Suite 10g)V10.1.2.0.2http://www.cnblogs.com/slightboy/archive/2008/08/30/489857.html#1303282whbh1984whbh1984Sat, 30 Aug 2008 14:03:39 GMThttp://www.cnblogs.com/slightboy/archive/2008/08/30/489857.html#1303282
whbh1984 2008-08-30 22:03 发表评论
]]>re: 通用分页存储过程http://www.cnblogs.com/slightboy/archive/2008/08/07/228874.html#1280303seeisseeisThu, 07 Aug 2008 01:39:19 GMThttp://www.cnblogs.com/slightboy/archive/2008/08/07/228874.html#1280303
seeis 2008-08-07 09:39 发表评论
]]>re: MSSQL 2005 分页分析及优化 http://www.cnblogs.com/slightboy/archive/2008/05/23/1204281.html#1206958slightboyslightboyFri, 23 May 2008 05:51:41 GMThttp://www.cnblogs.com/slightboy/archive/2008/05/23/1204281.html#1206958
以前测试代码丢了, 以后有空再写

slightboy 2008-05-23 13:51 发表评论
]]>re: MSSQL 2005 分页分析及优化 http://www.cnblogs.com/slightboy/archive/2008/05/23/1204281.html#1206578ddddddddFri, 23 May 2008 00:55:25 GMThttp://www.cnblogs.com/slightboy/archive/2008/05/23/1204281.html#1206578
dddd 2008-05-23 08:55 发表评论
]]>re: MSSQL 2005 分页分析及优化 http://www.cnblogs.com/slightboy/archive/2008/05/22/1204281.html#1205874slightboyslightboyThu, 22 May 2008 05:24:25 GMThttp://www.cnblogs.com/slightboy/archive/2008/05/22/1204281.html#1205874
我用的不正是 row number 吗

slightboy 2008-05-22 13:24 发表评论
]]>re: MSSQL 2005 分页分析及优化 http://www.cnblogs.com/slightboy/archive/2008/05/22/1204281.html#1205737zzticzh2zzticzh2Thu, 22 May 2008 02:59:33 GMThttp://www.cnblogs.com/slightboy/archive/2008/05/22/1204281.html#1205737
zzticzh2 2008-05-22 10:59 发表评论
]]>re: MSSQL 2005 分页分析及优化 http://www.cnblogs.com/slightboy/archive/2008/05/22/1204281.html#1205657wakaka1wakaka1Thu, 22 May 2008 02:05:55 GMThttp://www.cnblogs.com/slightboy/archive/2008/05/22/1204281.html#1205657
wakaka1 2008-05-22 10:05 发表评论
]]>re: MSSQL 2005 分页分析及优化 http://www.cnblogs.com/slightboy/archive/2008/05/22/1204281.html#1205651金色海洋（jyk）金色海洋（jyk）Thu, 22 May 2008 02:00:14 GMThttp://www.cnblogs.com/slightboy/archive/2008/05/22/1204281.html#1205651那么哪些数据放在第一页？哪些数据放在第二页，哪些数据是要放在后几页的？

怎么区分，如何判定，又如何获取？这些都十分也要做的事情。

或者说，不分页，如何确定第二页显示哪些数据？

金色海洋（jyk） 2008-05-22 10:00 发表评论
]]>