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注册。