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
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