sql server 分页语句

DECLARE @sql NVARCHAR(max)
DECLARE @pageSize INT
DECLARE @pageIndex INT

SET @pageSize= 20
SET @pageIndex= 1

SET @sql='select top '+STR(@pageSize)+' * from (select row_number() over(order by id asc) as rownumber,* from dbo.ci_menu)t where rownumber>(('+STR(@pageIndex-1)+')*'+STR(@pageSize)+')'
EXECUTE (@sql)

select top 20 * from (select row_number() over(order by id asc) as rownumber,* from dbo.ci_menu)t where rownumber>((1-1)*20);

select top 100 id,name ,number ,cCategory ,cCategoryName as customerType,taxRate ,amount ,periodMoney ,difMoney ,beginDate ,remark ,place ,linkMans ,type ,
contact ,cLevel ,cLevelName ,pinYin ,disable as 'delete' ,isDelete from (select row_number() over(order by id asc) as rownumber,* from dbo.ci_menu  where isDelete=0  and type=-10)t where rownumber>((1-1)*100);