| 本月文章推荐 |
分页存储过程2000发表日期：2006-11-16
|
|
CREATE procedure GetUsers
(@pagesize int, @pageindex int, @docount bit) as set nocount on if(@docount=1) select count(userId) from Users else begin declare @indextable table(id int identity(1,1),nid int) declare @PageLowerBound int declare @PageUpperBound int set @PageLowerBound=(@pageindex-1)*@pagesize set @PageUpperBound=@PageLowerBound+@pagesize set rowcount @PageUpperBound insert into @indextable(nid) select userId from Users order by userName desc select O.* from Users O,@indextable t where O.userId=t.nid and t.id>@PageLowerBound and t.id<=@PageUpperBound order by t.id end set nocount off GO |
| 上一篇：分页存储过程2005
人气:6016 下一篇：在SQL Server 2005中用存储过程实现搜索功能 人气:6247 |
| 浏览全部分页存储过程的内容
Dreamweaver插件下载 网页广告代码 祝你圣诞节快乐 2009年新年快乐 |
