EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

SQL options


CheckBox Concatenation is NULL if operand NULL (CONCAT_NULL_YIELDS_NULL)

When this option is enabled, if one of the operands in a concatenation operation is NULL, the result of the operation is NULL.

When disabled, concatenating a null value with a character string yields the character string as the result; the null value is treated as an empty character string.

 

CheckBox Allows identifiers in double quotation marks (QUOTED_IDENTIFIER)

When this option is enabled, identifiers can be delimited by double quotation marks and literals must be delimited by single quotation marks.

When disabled, identifiers cannot be in quotation marks and must follow all Transact-SQL rules for identifiers. Literals can be delimited by either single or double quotation marks.

 

CheckBox Allow triggers to fire recursively (RECURSIVE_TRIGGERS)

When this option is enabled, triggers are allowed to fire recursively. When disabled, triggers cannot be fired recursively.

 

Database Properties - Options - SQL options

 

 

CheckBox Terminate on overflow or divide by zero (ARITHABORT)

When this option is enabled, an overflow or divide-by-zero error causes the query or batch to terminate. If the error occurs in a transaction, the transaction is rolled back. When disabled, a warning message is displayed if one of these errors occurs, but the query, batch, or transaction continues to process as if no error occurred.

 

CheckBox Error on loss of precision (NUMERIC_ROUNDABORT)

If this option is enabled, an error is generated when loss of precision occurs in an expression. When disabled, losses of precision do not generate error messages and the result is rounded to the precision of the column or variable storing the result.

 

The Compatibility Level option group controls the behavior of an instance of Microsoft® SQL Server™, setting behavior to match a specified version of SQL Server.

 

Collation can be either a Windows collation name or a SQL collation name. By default, the server collation is used.

 

 


See also:

Recovery options

ANSI options

Automation options

Cursor options

FileTable options

Advanced