Paging Example in Sql Server (like mysql LIMIT+OFFSET)

SqlServerPagingExample.sql

-- Pageing in SQL Server like mysql (LIMIT + OFFSET)
DECLARE @Offset INT = 3
DECLARE @Limit INT = 10

;WITH Results_CTE AS
(
    SELECT        
        COUNT(*) OVER () as TotalRows,
        ROW_NUMBER() OVER (ORDER BY name) AS RowNum,
        id, name, crdate, refdate
    FROM master..sysobjects
    WHERE xtype = 'S'
)
SELECT *
FROM Results_CTE
WHERE RowNum >= @Offset
AND RowNum < @Offset + @Limit