本文介绍了一个使用SQL创建的存储过程CountPages，该过程用于计算数据库中特定表的总页数，支持指定每页大小及查询条件。
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
扫一扫
1041
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
