SQL Server查询分页存储过程

ALTER PROCEDURE [dbo].[pro_splitpage]
(
    @SQL NVARCHAR(4000),         --要执行的SQL语句
    @PAGE INT = 1,              --要显示的页码
    @PAGESIZE INT,              --每页的大小
    @PAGECOUNT INT = 0 OUT,     --总页数
    @RECORDCOUNT INT = 0 OUT    --总记录数
)
AS
BEGIN
    SET NOCOUNT ON

    DECLARE @P1 INT

    EXEC SP_CURSOROPEN @P1 OUTPUT, @SQL, @SCROLLOPT = 1, @CCOPT = 1, @ROWCOUNT = @PAGECOUNT OUTPUT

    SET @RECORDCOUNT = @PAGECOUNT

	SELECT @PAGECOUNT=
       CEILING(1.0 * @PAGECOUNT / @PAGESIZE) , @PAGE = (@PAGE-1) * @PAGESIZE + 1

   EXEC SP_CURSORFETCH @P1, 16, @PAGE, @PAGESIZE 
   EXEC SP_CURSORCLOSE @P1
END