:::: MENU ::::

ANSI NULL Enabled (ANSI_NULLS) in SQL Server T-SQL

  • Nov 05 / 2008
  • 0
dbDigger, T-SQL Interview Questions

ANSI NULL Enabled (ANSI_NULLS) in SQL Server T-SQL

You can use ANSI NULL Enabled to determine how NULL values are compared.

When set to TRUE in SQL Server Management Studio or ON when using the ALTER DATABASE command, all comparisons to a null value evaluate to UNKNOWN.

When set to FALSE, comparisons of non-UNICODE values to a null value evaluate to TRUE if both values are NULL.

It is important to note that Connection-level settings override the default database setting.

Consult us to explore the Databases. Contact us