GitHub

SQL Server: consider switching from COALESCE to ISNULL #32519

Also, check if the same thing happens on other databases, i.e. whether this should be a SQL Server-only change or something with a wider scope. SQL Server documentation detailing all the above, plus ...
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 ...
GitHub

SQL Syntax ISNULL(column1,column2) is Not supported after 1.6.0

With upgrade to 1.6.0 , ISNULL / COALESCE syntax is having issue in Order by . .OrderBy(" ISNULL( Col1, Col2) ") "No property or field 'ISNULL' exists in type 'ClassName' (at index 0) at ...