O'Reilly logo
  • Dustin Waybright thinks this is interesting:

T-SQL provides the predicate IS NULL to return a true when the tested operand is NULL

From

Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

Note

Would need to add ISNULL in an OR statement to return NULL rows.