OleDbSqlServerEffectiveSettings Properties
The OleDbSqlServerEffectiveSettings type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
|
AnsiNullDefaultOff |
ANSI_NULL_DFLT_OFF. Alters the session's behavior not to use ANSI compatibility for nullability. New columns defined without explicit nullability do not allow nulls.
|
|
|
AnsiNullDefaultOn |
ANSI_NULL_DFLT_ON. Alters the session's behavior to use ANSI compatibility for nullability. New columns defined without explicit nullability are defined to allow nulls.
|
|
|
AnsiNulls |
ANSI_NULLS. Controls NULL handling when using equality operators.
|
|
|
AnsiPadding |
ANSI_PADDING. Controls padding of fixed-length variables.
|
|
|
AnsiWarning |
ANSI_WARNINGS. Controls truncation and NULL in aggregate warnings.
|
|
|
ArithAbort |
ARITHABORT. Terminates a query when an overflow or divide-by-zero error occurs during query execution.
|
|
|
ArithIgnore |
ARITHIGNORE. Returns NULL when an overflow or divide-by-zero error occurs during a query.
|
|
|
ConcatNullYieldsNull |
CONCAT_NULL_YIELDS_NULL. Returns NULL when concatenating a NULL value with a string.
|
|
|
CursorCloseOnCommit |
CURSOR_CLOSE_ON_COMMIT. Controls behavior of cursors after a commit operation has been performed.
|
|
|
DisableDeferredConstraintChecking |
DISABLE_DEF_CNST_CHK. Controls interim or deferred constraint checking.
|
|
|
NoCount |
NOCOUNT. Turns off the message returned at the end of each statement that states how many rows were affected.
|
|
|
NumericRoundAbort |
NUMERIC_ROUNDABORT. Generates an error when a loss of precision occurs in an expression.
|
|
|
QuotedIdentifier |
QUOTED_IDENTIFIER. Differentiates between single and double quotation marks when evaluating an expression.
|
|
|
XactAbort |
XACT_ABORT. Rolls back a transaction if a Transact-SQL statement raises a run-time error.
|