When ANSI_NULLS is ON, a SELECT statement that uses WHERE column_name = NULL returns zero rows even if there are null values in column_name. A SELECT statement that uses WHERE column_name <> NULL ...

Offering tips and techniques, as well as the best solutions to old and new challenges, this book features new examples and updates to SQL-99, expanded sections of Query techniques, and a new section ...

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