04 2012 档案

一个简单的SQl存储过程分页
摘要：create proc Pro_name@pagesize int,@pageindex intasselect * from(select ROW_NUMBER() over( order by ARTICLEID)number ,* from ArticleInfo)t where t.number>(@pageindex-1)*@pagesize and t.number<=@pageindex*@pagesizego 阅读全文
posted @ 2012-04-29 10:03 王小贝 阅读(145) 评论(0) 推荐(0)