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

isnull-geometry-data-type.md

The type of a geometry instance is null. Returns 0 if the instance isn't null. This method is primarily used by the SQL Server infrastructure; it isn't recommended that you use IsNull to test whether ...
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 ...
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 ...
Ars Technica

SSRS: Can't use ISNULL properly in report designer - help

=IIF(IsNULL(Fields!Facility.Value), "N/A", Fields!Facility.Value)<BR><BR>Why doesn't that work in a text box in a report?<BR><BR>My syntax is correct isn't it?<BR><BR>It says "Name IsNULL is not ...