declare @nRowsPerPage int;
declare @nPage int;

select 
	@nRowsPerPage = 25,
	@nPage = 142;

select x.*
from (
		select row_number() over (order by col.object_id, col.name) as rowNB, col.*
		from sys.columns col
	) x
where x.rowNB > (@nRowsPerPage * (isnull(@nPage,0) - 1)) and x.rowNB <= (@nRowsPerPage * isnull(@nPage,0))
order by x.rowNB;


select top (@nRowsPerPage) x.*
from (
		select row_number() over (order by col.object_id, col.name) as rowNB, col.*
		from sys.columns col
	) x
where x.rowNB > (@nRowsPerPage * (isnull(@nPage,0) - 1))
order by x.rowNB;