Post
Ask Question

Nullable Parameter of SQL StoreProcedure

This following code gives example, how to declare null able parameter inside a store procedure: 
  1. CREATE PROCEDURE [dbo].[usp_Customer]  
  2. @CustomerID int,  
  3. @CustomerName nvarchar(50) = NULL,  
  4. AS  
  5. BEGIN  
  6. END