SET ANSI_NULLS#

Specifies ISO compliant behavior of the Equals (=) and Not Equal To (<>) comparison operators when they are used with null values.

Syntax#

SET ANSI_NULLS { ON | OFF }  [;]

Remarks#

Argument values are ignored and do not change the default behavior.

Permissions#

Requires membership in the public role.

See Also#