How to handle null values in a SQL Server query ISNULL, NULLIF, COALESCE, IS NULL , IS NOT NULL

Channel Avatar
Comment
X
Share
How to handle null values in a SQL Server query ISNULL, NULLIF, COALESCE, IS NULL , IS NOT NULL
How to handle null values in a SQL Server query ISNULL, NULLIF, COALESCE, IS NULL , IS NOT NULL
This videos shows some inbuilt functions to be used when querying records or checking null values.
The functions used are as follows
isnull(expression, value if null)
nullif(expression1, expression2)
coalesce(expression1,expression2…expressionn)
is where caluse
column is null
column is not null

Credits:
Music : YouTube Audio Library
Technologies : SQL Server Express Edition, SQL

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *