Nullable Parameter of SQL StoreProcedure

11y1.4kCode

This example of declaring null able parameter inside store procedure.

This following code gives example, how to declare null able parameter inside a store procedure:

CREATE PROCEDURE [dbo].[usp_Customer]
@CustomerID int,
@CustomerName nvarchar(50) = NULL,
AS
BEGIN
END