:::: MENU ::::

ANSI Warnings Enabled (ANSI_WARNINGS) in SQL Server T-SQL

  • Nov 05 / 2008
  • 0
dbDigger, Performance Tunning and Optimization, T-SQL Interview Questions

ANSI Warnings Enabled (ANSI_WARNINGS) in SQL Server T-SQL

ANSI Warnings option is used to determine the behavior of certain exception conditions. When set to TRUE in SQL Server Management Studio or ON when using the ALTER DATABASE command, errors or warnings are issued when conditions such as divide-by-zero occur or null values appear in aggregate functions.
When set to FALSE, no warning is raised, and instead a NULL value is returned. It is important to note that connection-level settings that are set by using the SET statement override the default database setting.

Consult us to explore the Databases. Contact us