Online Documentation for SQL Manager for SQL server

SQL options

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.

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.

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.

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.

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.