Make parameters nullable in sql server Code Example
make parameters nullable in sql server
In order for you to make parameters optional just asign null to them.
CREATE PROCEDURE MyProcedure
@MyFirstParameter BIGINT = NULL,
@SecondParameter BIT = NULL
AS
BEGIN
--Write your code here.
END