findnerd.com

Differences Between IsNull() and Coalesce() Functions?

1)ISNULL function is regraded as Transact-SQL function. 2)This function is used to replace NULL with the replacement value specified in second argument or from from the input expression it returns ...
GitHub

SQL Server: consider switching from COALESCE to ISNULL

It seems that COALESCE may be expanded to a CASE/WHEN, which causes the expression to get evaluated twice (link); ISNULL apparently doesn't have this behavior. This has a performance impact (i.e. when ...
GitHub

how-do-i-use-the-isnull-function-in-google-bigquery.md

The ISNULL function in Google BigQuery is used to check if a value is null. It returns true if a value is null and false if a value is not null. The code above checks if the value of the column ...
Ars Technica

Settle an argument: SQL update with left join + isnull() vs inner join

I've been in an argument with one of our devs that took an update statement with an inner join and made it a left join (because inner was missing some records somehow in the left table - tableB in ...