Sql

Search

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: rebuild index sql server
Sql :: mysql group by
Sql :: how to find max and min salary in sql
Sql :: delete from select postgresql
Sql :: mysql on kubernetes
Sql :: get current date sql
Sql :: sql table backup
Sql :: sql date with month and year only
Sql :: alter table drop partition hive
Sql :: if else sql
Sql :: control files oracle
Sql :: add column mysql with foreign key
Sql :: how to check default value of column in sql server
Sql :: sql comments
Sql :: stored procedure sql
Sql :: install mysql
Sql :: back up stored procedures mysql
Sql :: oracle last connection
Sql :: grant select mysql
Sql :: oracle list partitioned tables
Sql :: tsql find procedure with name
Sql :: dns slave zone convert
Sql :: Host ' is not allowed to connect to this MySQL server
Sql :: create user with encrypted password postgresql
Sql :: check constraint in ms sql
Sql :: sql join on wildcard
Sql :: sql max count
Sql :: into operator in sql
Sql :: long string type sql
Sql :: reset postgresql password windows

Search

SQL

make parameters nullable in sql server

ADD CONTENT