/SQL/Sql stored procedure update if parameter is not null

Sql stored procedure update if parameter is not null

Update [Users]
set    FirstName = IsNull(@FirstName, FirstName),
	   -- If you want to check for empty strings as well
       City = ISNULL(NULLIF(@City, ''), City),
       ....
Where  ...

Source: stackoverflow.com

Similar codes

1 vote290 views3 answers
Divide by zero error in sql
SQL
-1 vote235 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote271 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
11 votes284 views1 answer
Mysql order by two columns priority
SQL
9 votes530 views2 answers
Current date in postgresql minus 1 day
SQL
0 vote282 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote280 views1 answer
How to select only id where is not in column mysql
SQL
2 votes269 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote270 views1 answer
RowDataPacket
SQL
3 votes277 views1 answer
Two selects in one query
SQL