ALTER PROCEDURE [dbo].[PersonPage] 
	@Fake0 INT,
	@Start INT,
	@Fake1 INT
AS
BEGIN

	SET NOCOUNT ON;
	
	WITH p AS (SELECT ROW_NUMBER() OVER (ORDER BY PersonId) AS RN, p.*
				FROM Persons AS p)
	SELECT p.PersonId, p.FirstName, p.LastName
	FROM p
	WHERE p.RN BETWEEN @Start AND @Start + 1
END

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="HiberTest.Models" namespace="HiberTest.Models">
  <sql-query name="PersonPage">
    <query-param name="Start" type="Int32"/>
    <query-param name="Fake0" type="Int32"/>
    <query-param name="Fake1" type="Int32"/>
    <return class="Person" />
    EXEC PersonPage :Start, :Fake0, :Fake1
  </sql-query>
</hibernate-mapping>

 EXEC PersonPage :Fake0, :Start, :Fake1