/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 vote211 views4 answers
Restart MySQL
SQL
0 vote247 views1 answer
Html css mobile menu arrow dropdown
SQL
2 votes204 views1 answer
Mariadb JSON_EXTRACT
SQL
0 vote195 views1 answer
Longtext sql
SQL
0 vote219 views1 answer
Sql doesn't contain
SQL
0 vote219 views1 answer
Extract sql from query object sqlalchemy
SQL
17 votes219 views6 answers
Change column name in sql
SQL
13 votes195 views2 answers
Check if value is null mysql
SQL
8 votes196 views1 answer
Oracle add months to sysdate
SQL
0 vote209 views2 answers
How covert into int in maria db
SQL