WEB开发网
开发学院数据库MSSQL Server Sql server 2005带来的分页便利 阅读

Sql server 2005带来的分页便利

 2007-11-11 12:54:11 来源:WEB开发网   
核心提示:select threadid from (select threadid, ROW_NUMBER() OVER (order by stickydate) as Pos from cs_threads) as T where T.Pos > 100000 and T.Pos < 100030===如果里面

select threadid from
(
select threadid, ROW_NUMBER() OVER (order by stickydate) as Pos from cs_threads
) as T
where T.Pos > 100000 and T.Pos < 100030

===========================================

如果里面的这个表cs_threads数据量超大,比如,几亿条记录,那这个方法应该是有问题的

因为,select threadid from
(
select threadid, ROW_NUMBER() OVER (order by stickydate) as Pos from cs_threads
) as T
where T.Pos > 100000 and T.Pos < 100030
这个语句是把select threadid, ROW_NUMBER() OVER (order by stickydate) as Pos from cs_threads它全部取出来,然后在SQL的外面进行分页的,没在SQL2005上测试过,因为原先在Oracle(大型网站数据库平台)上这样的写法是不好的,Oracle(大型网站数据库平台)中这样写比较好:select threadid from
(
select threadid, ROW_NUMBER() OVER (order by stickydate) as Pos from cs_threads a where a.pos<100030
) as T
where T.Pos > 100000

出处:blog.joycode.com/dotey/archive/2006/01/16/70493.aspx

Tags:Sql server 带来

编辑录入:coldstar [复制链接] [打 印]
赞助商链接