else
set@pageTotal=@total%@pageSize
print'请输入正确的页码数总条数为：'+cast(@totalaschar(5))+'总页数为：
'+cast(@pageTotalaschar(5)) go
declare@pageTotalint
execusp_Student_page@pageTotaloutput,2,5 print@pageTotal
end
selecttop (@pageSize)*fromStudentwhereStudentNonotin
(selecttop ((@pageCurrent-1)*(@pageSize))StudentNofromStudent) else
row_number()分页
select ROW_NUMBER() over(order by studentNo) as 序号, * from Student
select row_number() over (order by [SubjectResult] desc) as 成绩,* from Result
createprocusp_Bank_Page2 as
else begin
IF(@rowSatart>@pageTotal) BEGIN END
PRINT'总条数为：'+CAST(@pageTotalASVARCHAR(20))+'请确认输入数目' SELECT@pageTotal=COUNT(*) FROMCustomer
declare@rowSatartint,@rowEndint
set@rowSatart=(@pageCurrent-1)*@pageSize+1 set@rowEnd=@pageCurrent*@pageSize @pageCurrentint, @pageSizeint, @pageTotalINTOUTPUT
go
select*from
(select*,ROW_NUMBER()over (orderbycustId)asnumberfromcustomer)ast wheret.numberbetween@rowSatartand@rowEnd end