sql 又一分页代码

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