CREATE PROCEDURE GetBooks
	@LikeTitle NVARCHAR( 50 )
AS
BEGIN	
	SET NOCOUNT ON;

	SELECT ID, ISBN, Title FROM Books
	WHERE Title LIKE @LikeTitle
END

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" namespace="..." assembly="...">
	<sql-query name="BookQuery" callable="true">
		<query-param name="LikeTitle" type="string" />
		<return class="Book">
			<return-property column="ID" name="ID" />
			<return-property column="ISBN" name="ISBN" />
			<return-property column="Title" name="Title" />
		</return>
		EXEC GetBooks @LikeTitle =:LikeTitle
	</sql-query>
</hibernate-mapping>