/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

1 vote341 views2 answers
Mysql extract month
SQL
1 vote372 views1 answer
Mysql previous year
SQL
0 vote356 views1 answer
Mariadb current date plus 1 day
SQL
8 votes333 views1 answer
Mysql restore database
SQL
3 votes359 views2 answers
How to start mysql in terminal
SQL
0 vote345 views1 answer
Postgres reorder columns
SQL
1 vote355 views3 answers
Execute sp in sql server
SQL
0 vote330 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote403 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
1 vote417 views1 answer
Oracle select first row order by
SQL