SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create PROCEDURE [dbo].[USP_GetPageData]
(
@SQLSTR VARCHAR(8000), /* 查询的SQL语句 */
@CURPAEG INT, /* 当前页面位置 */
@PAGESIZE INT /* 页面显示的数据行数 */
)
AS
begin
SET NOCOUNT ON
DECLARE @P1 INT, /* 游标 */
@ROWCOUNT int,
@COUNTPAGE int,
@CurRow int
EXEC sp_cursoropen @P1 OUTPUT, @SQLSTR,@scrollopt=1,@ccopt=1,@ROWCOUNT=@ROWCOUNT OUTPUT
if @ROWCOUNT % @PAGESIZE >0
set @COUNTPAGE=@ROWCOUNT/@PAGESIZE+1
else
set @COUNTPAGE=@ROWCOUNT/@PAGESIZE
if @CURPAEG>@COUNTPAGE set @CURPAEG=@COUNTPAGE
set @CurRow=(@CURPAEG-1)*@PAGESIZE+1
SET NOCOUNT OFF
select @CURPAEG CURPAEG,@PAGESIZE PageSize,@COUNTPAGE COUNTPAGE,@ROWCOUNT [ROWCOUNT]
EXEC sp_cursorfetch @P1,16,@CurRow,@PAGESIZE
SET NOCOUNT on
EXEC sp_cursorclose @P1
end
sql 又一分页代码
最新推荐文章于 2024-04-06 22:51:49 发布