Check out example codes for "ANSI_NULLS sql server". It will help you in understanding the concepts better.

Code Example 1

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 returns zero rows even if there are nonnull values in column_name.

Learn ReactJs, React Native from akashmittal.com