摘要：create proc getdatabypage@pagesize int,@pageindex intasbegin select * from (select *, ROW_NUMBER() over(order by id) as pageindex from MyOrders) as t1 where t1.pageindex between(@pageindex-1)*@pagesize+1 and @pagesize*@pageindexend 阅读全文