获取分页后的总页数

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:  Ray
-- Create date: 2007-4-3
-- Description: Count Pages
-- =============================================
CREATE PROCEDURE CountPages
 @PageSize int,
 @TableName varchar(100),
 @where varchar(500), --有条件时,必须加上 where
 @Pages int output
AS
BEGIN
 SET NOCOUNT ON;
 DECLARE @sql nvarchar(1000)
 SET @sql='SELECT @Pages=CEILING((COUNT(*)+0.0)/'+CAST(@PageSize AS varchar)+
         ') FROM '+@TableName+@where
 EXEC sp_executesql @sql,N'@Pages int OUTPUT',@Pages OUTPUT--计算总页数
END
GO