This will select rows from the table
OFFSET which is simply calculated as
(@page - 1) * @rows
Example: (2 - 1) * 25 = 25
FETCH NEXT then simply returns the next
@rows which was 25.
For this to work we order by the
id DESC so the most recent records are at the top.
EXEC dbo.[prc_select_some_crap] @page = 2, @rows = 25;
Changing the values
@rows should show the results if you cannot create stored procs.
DECLARE @page INT = 5;