Parametri opzionali in Stored Procedure

USE tempdb;
GO

CREATE PROCEDURE dbo.up_GetUser(
@FirstName varchar(10) = 'Lorenzo',
@LastName varchar(10) = 'Benaglia'
)
AS
SELECT 
      @FirstName AS FirstName
    , @LastName AS LastName;
GO

EXEC dbo.up_GetUser;

/* Output:

FirstName  LastName
---------- ----------
Lorenzo    Benaglia

(1 row(s) affected)

*/

EXEC dbo.up_GetUser 'David';

/* Output:

FirstName  LastName
---------- ----------
David      Benaglia

(1 row(s) affected)

*/

EXEC dbo.up_GetUser 'David', 'De Giacomi';

/*

FirstName  LastName
---------- ----------
David      De Giacomi

(1 row(s) affected)

*/

DROP PROCEDURE dbo.up_Getuser;