When SET ANSI_NULLS is OFF then which one is true?
A SELECT statement that uses WHERE column_name = NULL returns no results
A SELECT statement that uses WHERE column_name = NULL returns the rows that have null values in column_name.
A SELECT statement that uses WHERE column_name = NULL will throw error.
A SELECT statement that uses WHERE column_name = NULL returns all the rows.