SQL Server A relatively good paging stored procedure P_splitpage

CREATE procedure P_splitpage@sql nvarchar (4000),--The SQL statement to execute @page int=1,    --the page number to display @pagesize int,  -- Size per page @pagecount int=0 out,--total number of pages @recordcount int=0 out--Total records asset nocount Ondeclare @p1 intexec sp_cursoropen @p1 output, @sql, @scrollopt =1, @ccopt =1,@[email protected] outputset @recordCount = @pageCountselect @pagecount =ceiling (1.0*@ pagecount/@pagesize), @page = (@page-1) * @pagesize +1exec sp_cursorfetch @p1, @page, @pagesizeexec sp_cursorclose @ P1go

SQL Server A relatively good paging stored procedure P_splitpage