Comparing NULL values in SQL Server

Comparing a field or variable to NULL. It’s important to remember that a T-SQL syntax should use the IS operator in place of the Equals (=) and Not Equal To (<>) operators. This is a behavior setting in SQL Server called ANSI_NULLS. When SET ANSI_NULLS is ON, a SELECT statement that uses WHERE column_name = […]