用于分页的存储过程
来源:互联网 发布:pc3000数据恢复论坛 编辑:程序博客网 时间:2024/05/16 01:00
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
CREATE PROCEDURE usp_PagedUserReg
@iPage int,
@iPageSize int
AS
Begin
--关闭自动计数器功能
SET NOCOUNT ON
--declare variables
declare @iStart int -- start record
declare @iEnd int -- end record
declare @iPageCount int -- total number of pages
-- create the temporary table 建临时表
Create Table #PagedUserReg
(
id int identity,
UserID int(4) ,
Nick char(20) ,
Truename char(10) ,
email char(100) ,
department char(50) ,
zhuanye char(50) ,
mnianji char(50) ,
sex char(10) ,
birthday datetime ,
pwd char(20) ,
room char(10) ,
telphon char(50) ,
qustion char(100) ,
answer char(50) ,
imagepath char(100)
)
-- populate the temp table 加入数据
insert into #PagedUserReg (Userid,Nick,Truename,email,department,
zhuanye,mnianji,sex,birthday,pwd,room,telphon,qustion,answer,
imagepath)
select Userid,Nick,Truename,email,department,
zhuanye,mnianji,sex,birthday,pwd,room,telphon,qustion,answer,
imagepath
From RegUser
-- work out how many pages there are in total 计算总页数
select @ipageCount=Count(*)
from RegUser
select @ipageCount = Ceiling(@iPageCount / @iPageSize)+1
-- Check the Page number
if @iPage <1
select @ipage=1
if @iPage>@ipageCount
select @ipage = @ipageCount
-- calculate the start and end records
select @iStart = (@iPage-1) * @iPageSize
select @iEnd = @istart + @ipageSize + 1
-- select only those records that fall within our page
select * From #PagedUserReg
where ID > @iStart
and ID < @iEnd
Drop Table #PagedUserReg
-- turn back on record counts
set nocount off
-- return the number of records left
Return @iPageCount
end
于分页的存储过程';return true">
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
/*该存储过程用于显示注册用户的分页*/CREATE PROCEDURE usp_PagedUserReg
@iPage int,
@iPageSize int
AS
Begin
--关闭自动计数器功能
SET NOCOUNT ON
--declare variables
declare @iStart int -- start record
declare @iEnd int -- end record
declare @iPageCount int -- total number of pages
-- create the temporary table 建临时表
Create Table #PagedUserReg
(
id int identity,
UserID int(4) ,
Nick char(20) ,
Truename char(10) ,
email char(100) ,
department char(50) ,
zhuanye char(50) ,
mnianji char(50) ,
sex char(10) ,
birthday datetime ,
pwd char(20) ,
room char(10) ,
telphon char(50) ,
qustion char(100) ,
answer char(50) ,
imagepath char(100)
)
-- populate the temp table 加入数据
insert into #PagedUserReg (Userid,Nick,Truename,email,department,
zhuanye,mnianji,sex,birthday,pwd,room,telphon,qustion,answer,
imagepath)
select Userid,Nick,Truename,email,department,
zhuanye,mnianji,sex,birthday,pwd,room,telphon,qustion,answer,
imagepath
From RegUser
-- work out how many pages there are in total 计算总页数
select @ipageCount=Count(*)
from RegUser
select @ipageCount = Ceiling(@iPageCount / @iPageSize)+1
-- Check the Page number
if @iPage <1
select @ipage=1
if @iPage>@ipageCount
select @ipage = @ipageCount
-- calculate the start and end records
select @iStart = (@iPage-1) * @iPageSize
select @iEnd = @istart + @ipageSize + 1
-- select only those records that fall within our page
select * From #PagedUserReg
where ID > @iStart
and ID < @iEnd
Drop Table #PagedUserReg
-- turn back on record counts
set nocount off
-- return the number of records left
Return @iPageCount
end
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
- 用于分页的存储过程
- 用于分页的存储过程
- 用于分页的MySQL存储过程
- 分页的存储过程
- 分页的存储过程
- 分页的存储过程
- 分页的存储过程
- 分页的存储过程
- 分页的存储过程
- 分页的存储过程
- 存储过程的分页!!
- 分页的存储过程
- 分页的存储过程
- 分页的存储过程
- 分页的存储过程
- 分页的存储过程
- 分页的存储过程
- 分页的存储过程
- Dot Net的调试 - 1
- 在VB.NET中如何运用StrConv
- .net时代的网络世界语:xml
- 微软对.net的定义
- C#中的事件
- 用于分页的存储过程
- 当WEB SERVICE流行以后...(转)
- 访问修饰符(二)
- c#自定义控件开发实例(1)
- 我的推荐:在VB.NET中寻找App
- 一个文件上传的类
- Visual Basic .NET 代码示例:与 Windows 服务交互 (2003年2月17日)
- 附:创建 Windows XP 图标
- JIT编译