一个简单的分页代码,如下:
select * from (
select top (pagesize) * from (
select top (currentpage*pagesize) * from [dbo].[Area] order by id asc
) as myfirst
order by id desc
) as mysecond
order by id asc
如果数据量大的话,这个方法是很慢的。
一个简单的分页代码,如下:
select * from (
select top (pagesize) * from (
select top (currentpage*pagesize) * from [dbo].[Area] order by id asc
) as myfirst
order by id desc
) as mysecond
order by id asc
如果数据量大的话,这个方法是很慢的。