LISTING 2: Stored Procedure That Listing 1’s Template Calls

CREATE PROCEDURE showParams
@param1 sysname,
@param2 sysname = NULL,
@param3 sysname = NULL

AS

SELECT '<Parameters>'
SELECT '<Param1>' + @param1 + '</Param1>'
IF @param2 IS NOT NULL
SELECT '<Param2>' + @param2 + '</Param2>'
IF @param3 IS NOT NULL
SELECT '<Param3>' + @param3 + '</Param3>'
SELECT '</Parameters>'
RETURN