笑容

使用标准的SQL代码进行分页，通过动态合成查询语句来实现，简单易用，速度应该是不凡的。

例子：原 SQL
select
field1, field2 …
from ab c, cd e where 1=1 and
c.id = d.id
order by c.id

分页， SQL更改为
select  top 30
field1, field2 …
from ab c, cd e where 1=1 and
c.id = d.id

and c.id not in (
select top 200
c.id
from ab c, cd e where 1=1 and
c.id = d.id
order by c.id
)

order by c.id

其中 200是当前记录数，30是每页显示数

Popularity: 4% [?]