一个简单的SQL Server分页代码

一个简单的分页代码，如下：

 

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

如果数据量大的话，这个方法是很慢的。