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 ...
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 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback