§4.9 of the specification explictly states: SQL rules for the ordering of null values apply: that is, all null values must appear before all non-null values in the ordering or all null values must ...

SELECTs that perform a GROUP BY on a column that has no value in it, will not be returned in the results. This is related to/part of #32079.

Is your SQL drawing a blank? It’s NULL a surprise! The title of this post is a play on words, but very appropriate. We are going to discuss the inconsistent results, as well as performance ...

Your application of course will need to support it, and SQL server doesn't have a native "attribute" that I know of to say that "NULLs aren't allowed, but zero-length strings are...", you could ...