/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 vote163 views1 answer
Connect to ssms with python
SQL
0 vote181 views1 answer
Mariadb used space
SQL
0 vote153 views1 answer
Sql search all columns of database oracle sql
SQL
7 votes141 views1 answer
Append column sql
SQL
2 votes165 views1 answer
Postgresql transaction
SQL
0 vote154 views1 answer
How to join result table in mysql
SQL
0 vote210 views1 answer
Check user sql password from command line
SQL
0 vote151 views1 answer
Rename view mysql
SQL
0 vote132 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
17 votes165 views2 answers
Mysql date to string
SQL