笔记218 给定每页记录数计算一张表的总页数 @PageSize @PageIndex @TotalRecords @TableTotalPage 2012-11-22

笔记218 给定每页记录数计算一张表的总页数 @PageSize @PageIndex @TotalRecords @TableTotalPage 2012-11-22

--给定每页记录数计算一张表的总页数 @PageSize @PageIndex @TotalRecords @TableTotalPage 2012-11-22
USE [pratice]
DECLARE @PageIndex INT
DECLARE @PageSize INT
DECLARE @TableTotalPage INT
DECLARE @TotalRecords INT
SET @PageIndex = 1
SET @PageSize = 5


SELECT  @TotalRecords = COUNT(RecordNO)
FROM    DP_OilCanOption
PRINT @TotalRecords
IF ( @TotalRecords > 0 )
    BEGIN
        IF ( @TotalRecords % @PageSize = 0 )
            BEGIN

                SET @TableTotalPage = @TotalRecords / @PageSize
            END
        ELSE
            BEGIN
                SET @TableTotalPage = @TotalRecords / @PageSize + 1
            END
    END
PRINT @TableTotalPage