SyntaxFix

[sql] SQL Stored Procedure: If variable is not null, update statement

Yet another approach is ISNULL().

UPDATE [DATABASE].[dbo].[TABLE_NAME]
SET    
    [ABC]  = ISNULL(@ABC, [ABC]),
    [ABCD] = ISNULL(@ABCD, [ABCD])

The difference between ISNULL and COALESCE is the return type. COALESCE can also take more than 2 arguments, and use the first that is not null. I.e.

select COALESCE(null, null, 1, 'two') --returns 1
select COALESCE(null, null, null, 'two') --returns 'two'

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to tsql

• Passing multiple values for same variable in stored procedure • Count the Number of Tables in a SQL Server Database • Change Date Format(DD/MM/YYYY) in SQL SELECT Statement • Stored procedure with default parameters • Format number as percent in MS SQL Server • EXEC sp_executesql with multiple parameters • SQL Server after update trigger • How to compare datetime with only date in SQL Server • Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot • Printing integer variable and string on same line in SQL

Examples related to stored-procedures

• How to create temp table using Create statement in SQL Server? • How do I pass a list as a parameter in a stored procedure? • SQL Server IF EXISTS THEN 1 ELSE 2 • Stored procedure with default parameters • Could not find server 'server name' in sys.servers. SQL Server 2014 • How to kill all active and inactive oracle sessions for user • EXEC sp_executesql with multiple parameters • MySQL stored procedure return value • SQL Server: use CASE with LIKE • SQL server stored procedure return a table

Examples related to sql-update

• Update some specific field of an entity in android Room • How to perform update operations on columns of type JSONB in Postgres 9.4 • MySQL - UPDATE multiple rows with different values in one query • How to update multiple columns in single update statement in DB2 • Update Multiple Rows in Entity Framework from a list of ids • Update MySQL using HTML Form and PHP • CodeIgniter query: How to move a column value to another column in the same row and save the current time in the original column? • mysql after insert trigger which updates another table's column • Update values from one column in same table to another in SQL Server • I want to use CASE statement to update some records in sql server 2005