存储过程分页
摘要:
alter proc proc_Customers_pageindex( @pageindex int, @pagesize int,@count int output)as select @count=count(*) from Customers select * from ( select row_number() over(order by CustomerID) as 'rowindex',* from Customers) as Customers_pageindex where rowindex>@pageindex*@pagesize and rowindex<=( 阅读全文
posted @ 2011-02-19 22:56 蝸牛漫步 阅读(182) 评论(0) 推荐(1) 编辑