create procedure page @pagesize int, @pageindex int as select top (@pagesize) Id,Name,Sex,Tel from (select *,row_number() over(order by Id) as rownum from CardInfo) as a where rownum > (@pagesize*(@pageindex-1))
分页存储过程
最新推荐文章于 2022-06-28 17:00:47 发布