摘要： create proc up_GetPageData@pi int --页码@ps int --页容量asbeginselect * from (select ROW_NUMBER() over(order by id) as RNum,*from table) as tempwhere RNum>(@pi-1)*@ps and RNum<=@pi*@psend再来执行这一条语句execup_GetPageData 1,4 阅读全文