还是上次那个分页存储过程，修改了一下，返回两个表，前面是页数和总记录数，后面是记录表

select * from ReceiveFileRecord where checkcompelete = 1

 

select R.FileID, R.ReceiveDate,R.CreateUser,U.UserName,R.ComeUnit
from ReceiveFileRecord R left join UserBase U on R.CreateUser = U.UserID
where checkcompelete = 1

 

declare @TName varchar(2000)
set @TName=' ReceiveFileRecord R left join UserBase U on R.CreateUser = U.UserID '
exec  PaginationDisplay @TName,10,1,'R.FileID','asc','R.FileID, R.ReceiveDate,R.CreateUser,U.UserName,R.ComeUnit','  checkcompelete = 1 ',''

declare @int int ;
select @int = (select count(*) from  ReceiveFileRecord R left join UserBase U on R.CreateUser = U.UserID  where   checkcompelete = 1 );
declare @page int;
if @int%10 = 0
select @page = @int/10
else
select @page = @int/10+1;
select @page,@int

 

declare @int int ;select @int = (select count(*) from  ReceiveFileRecord R left join UserBase U on R.CreateUser = U.UserID  where   checkcompelete = 1 ); declare @page int; if @int%10 = 0 select @page = @int/10 else select @page = @int/10+1;select @page as page,@int as count

 

 

select top 10 R.FileID, R.ReceiveDate,R.CreateUser,U.UserName,R.ComeUnit from  ReceiveFileRecord R left join UserBase U on R.CreateUser = U.UserID  where  where checkcompelete = 1

本文使用Blog_Backup未注册版本导出，请到soft.pt42.com注册。