/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

4 votes133 views2 answers
How to insert ip address in mysql using php
SQL
0 vote167 views2 answers
Sql unique
SQL
1 vote114 views1 answer
Oracle finding duplicate records
SQL
0 vote177 views1 answer
Do you know sql
SQL
0 vote131 views1 answer
Copy data from one postgres container to another
SQL
0 vote121 views1 answer
Power bi find all ids not in other tables
SQL
8 votes141 views1 answer
Show mysql user table
SQL
-1 vote122 views3 answers
Check table exist postgresql
SQL
0 vote142 views1 answer
Create a plsql object
SQL
0 vote130 views1 answer
Get record which is available in one table but not in another mysql
SQL