ANSI_NULLS
Last updated
Last updated
This statement specifies the ISO-compliant behavior of the Equals and Not Equal to comparison operators when used with null values in SQLServer. Please visit to get more information about this statement.
"SET ANSI_NULLS ON affects a comparison only if one of the operands of the comparison is either a variable that is NULL or a literal NULL. If both sides of the comparison are columns or compound expressions, the setting does not affect the comparison." (SQLServer ANSI_NULLS article).
Snowflake does not support this statement, so in the case of ANSI_NULLS ON, this is marked with an FDM () because it does not have relevance in executing equal and not equal comparison operations. Here, you can find an explanation of the .
"When ANSI_NULLS is OFF, the Equals (=) and Not Equal To (<>) comparison operators do not follow the ISO standard. 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 returns the rows that have non-NULL values in the column". (SQLServer ANSI_NULLS article).
In the case of the ANSI_NULLS OFF statement, this one is marked with an EWI () because it requires extra manual effort.
: The statement is not supported in Snowflake
: SET ANSI_NULLS ON statement may have different behavior in Snowflake