/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

3 votes285 views1 answer
Oracle drop user
SQL
1 vote289 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote291 views1 answer
Copy row from db to db mysql
SQL
14 votes257 views2 answers
How to auto increment in sql
SQL
0 vote268 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
0 vote299 views2 answers
Temp Space
SQL
10 votes300 views2 answers
Doublon sql
SQL
0 vote286 views1 answer
Selecting duplicates
SQL
0 vote261 views1 answer
How to connect to mysql in ef 6
SQL
2 votes269 views1 answer
Oracle index size calculation
SQL