/SQL/Make parameters nullable in sql server

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

Similar codes

0 vote296 views2 answers
Default constraint in ms sql
SQL
0 vote318 views1 answer
Check database restore status sql script
SQL
0 vote278 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote283 views4 answers
Database stuck at restoring state
SQL
2 votes285 views3 answers
How to pass password mysql command line
SQL
3 votes288 views2 answers
Oracle apex view logs
SQL
0 vote283 views1 answer
Laravel eloquent get generated sql
SQL
19 votes295 views5 answers
Date between in mysql
SQL
0 vote312 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
1 vote297 views1 answer
Mysql select all and rename one
SQL