Online Documentation for SQL Manager for SQL server

ANSI options


CheckBox NULL is default for UDTs and columns (ANSI_NULL_DEFAULT)

When this option is enabled, all user-defined data types or columns that are not explicitly defined as NOT NULL during a CREATE TABLE or ALTER TABLE statement default to allowing null values. Columns that are defined with constraints follow constraint rules regardless of this option.

 

CheckBox Comparisons to null value evaluate to NULL (ANSI_NULLS)

When this option is enabled, all comparisons to a null value evaluate to NULL (unknown). When disabled, comparisons of non-Unicode values to a null value evaluate to TRUE if both values are NULL.

 

Database Properties - Options - ANSI options

 

CheckBox Warn on divide by zero and nulls in aggregate (ANSI_WARNINGS)

When this option is enabled, errors or warnings are issued when conditions such as "divide by zero" occur or null values appear in aggregate functions. When disabled, no warnings are raised when null values appear in aggregate functions, and null values are returned when conditions such as "divide by zero" occur.

 

CheckBox Not trim trailing blanks in varchar and varbinary (ANSI_PADDING)

When this option is enabled, trailing blanks in character values inserted into varchar or nvarchar columns and trailing zeros in binary values inserted into varbinary columns are not trimmed. Values are not padded to the length of the column. When disabled, the trailing blanks (for varchar or nvarchar) and zeros (for varbinary) are trimmed. This option affects only the definition of new columns.