2013年7月29日
存储过程分页 简单列子
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 Read More
posted @ 2013-07-29 11:38 lth艺笑 Views(87) Comments(0) Diggs(0) Edit