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 ...

NULL at top of WHERE We will have queries sometimes where the WHERE clause is going to evaluate for some given row to NULL, and the rule in that case that SQL has decided if the WHERE clause evaluates ...

NULL is a fickle beast, and for the people not accustomed to how it works in SQL, it can create many problems (read: incorrect data output). This is especially true for those coming from ...

Spread the loveNULL in SQL is a powerful concept, representing the absence of a value. It’s used when data is unavailable or unknown, but its usage requires careful consideration. The first step is ...

In this SQL Server tip, Arthur Fuller explains the effects of NULLs, and the different results obtained by inner and outer JOINs.

I'm trying to put together a DTS package to export data from SQL Server (2k) into a CSV file that I can in turn import into MySQL.The problem I'm running into is SQL Server exports NULL values as ...