高效分页

declare @pagesize int--每页大小 
declare @currentpage int--当前页 
set @pagesize=2 
set @currentpage=2


SELECT TOP (@pagesize) * FROM 
( SELECT  top(@pagesize*@currentpage) ROW_NUMBER() OVER (ORDER BY XingMBianH ) AS Num,XingMBianH FROM TJ_HT_XiangMu order by Num       ) 
as t 
WHERE t.Num > (@pagesize*(@currentpage-1)) 
order by t.Num;