Simple pager for sql server

tablePaginator.sql

CREATE PROCEDURE MyTablePagerSP
	@Page INT = 1,
	@SizePerPage INT = 100
AS
BEGIN
	SET NOCOUNT ON:
	
	SELECT FieldA, FieldB, FieldC
	FROM MyTable
	ORDER BY MyTable.SomeFieldIndexed	
	OFFSET @SizePerPage * (@Page - 1) ROWS
	FETCH NEXT @SizePerPage ROWS ONLY;
END
GO
-- How to use
-- EXEC MyTablePagerSP 1, 10
-- Output: First 10 rows. Order based on ordered column (MyTable.SomeFieldIndexed)