62,243
社区成员




declare @recordtotal int,@pagesize int
if @recordtotal % @pagesize = 0
BEGIN
return @RecordTotal / @pagesize
END
else
BEGIN
return @RecordTotal / @pagesize +1
END
Declare @myCount int
Declare @RecordTotal int
Declare @pageSize int
set @RecordTotal=1234
set @pageSize=100
set @myCount=Round(@RecordTotal/@pageSize,0,1)
if(@myCount=0)
print '正好分完,共'+cast(@myCount as nvarchar(10))+'页'
else
begin
set @mycount=@mycount+1
print '共'+cast(@myCount as nvarchar(10))+'页,其中有一页不足'+cast(@pageSize as nvarchar(10))
end