Tag: null
-
A (more) concise way to test a SQL MERGE for differences if there are nulls involved
—
in SQL ServerIn SQL, if you need to compare two columns that are both nullable, your compare statements can quickly get out of hand (and a lot less readable along the way). While fixing a bug in my code, I found out about a way to keep the comparison short and readable using the EXCEPT (or INTERSECT)…