How to create database paging Query

Create Procedure [ProcedureName]
@pageNum int  = 1,
@pageSize  int = 10
as


;WITH TablesAndColumns
AS (   
 SELECT
OBJECT_NAME(sc.object_id) AS TableName
,   name AS ColumnName
,  row_number()   OVER (ORDER BY object_name(sc.object_id))  AS Row
    FROM sys.columns sc
 ) 
SELECT *    FROM TablesAndColumns   
WHERE Row BETWEEN (@pageNum - 1) * @pageSize + 1   AND @pageNum * @pageSize ;