SQL Server: General paging stored procedures implemented using system stored procedures

Code

Create   Proc Sp_pageview
@ SQL Ntext , -- SQL statement to be executed
@ Pagecurrent   Int = 1 , -- Page number to be displayed
@ Pagesize Int = 10 , -- Size of each page
@ Pagecount Int Output -- Total number of pages
As
Set Nocount On
Declare   @ P1   Int
-- Initialize paging cursor
Exec Sp_cursoropen
@ Cursor = @ P1 Output,
@ Stmt = @ SQL ,
@ Scrolopt = 1 ,
@ Ccopt = 1 ,
@ Rowcount = @ Pagecount Output

-- Total number of pages
If   Isnull ( @ Pagesize , 0 ) < 1  
Set   @ Pagesize = 10
Set   @ Pagecount = ( @ Pagecount + @ Pagesize - 1 ) / @ Pagesize
If   Isnull ( @ Pagecurrent , 0 ) < 1   Or   Isnull ( @ Pagecurrent , 0 ) > @ Pagecount
Set   @ Pagecurrent = 1
Else
Set   @ Pagecurrent = ( @ Pagecurrent - 1 ) * @ Pagesize + 1

--Display data on a specified page
ExecSp_cursorfetch@ P1,16,@ Pagecurrent,@ Pagesize

--Disable paging cursor
ExecSp_cursorclose@ P1