SetOptions Enum

Definition

The various types of predicate SET options found in SQL.

This enumeration supports a bitwise combination of its member values.

[System.Flags]
[System.Serializable]
public enum SetOptions
[<System.Flags>]
[<System.Serializable>]
type SetOptions = 
Public Enum SetOptions
Inheritance
SetOptions
Attributes

Fields

AnsiDefaults 1024

ANSI_DEFAULTS

AnsiNullDfltOff 2048

ANSI_NULL_DFLT_OFF

AnsiNullDfltOn 4096

ANSI_NULL_DFLT_ON

AnsiNulls 8192

ANSI_NULLS

AnsiPadding 16384

ANSI_PADDING

AnsiWarnings 32768

ANSI_WARNINGS

ArithAbort 8

ARITHABORT

ArithIgnore 16

ARITHIGNORE

ConcatNullYieldsNull 2

CONCAT_NULL_YIELDS_NULL

CursorCloseOnCommit 4

CURSOR_CLOSE_ON_COMMIT

DisableDefCnstChk 4194304

DISABLE_DEF_CNST_CHK

FmtOnly 32

FMTONLY

ForcePlan 65536

FORCEPLAN

ImplicitTransactions 524288

IMPLICIT_TRANSACTIONS

NoBrowsetable 16777216

NO_BROWSETABLE

NoCount 64

NOCOUNT

NoExec 128

NOEXEC

None 0

None

NumericRoundAbort 256

NUMERIC_ROUNDABORT

ParseOnly 512

PARSEONLY

QuotedIdentifier 1

QUOTED_IDENTIFIER

RemoteProcTransactions 1048576

REMOTE_PROC_TRANSACTIONS

ShowPlanAll 131072

SHOWPLAN_ALL

ShowPlanText 262144

SHOWPLAN_TEXT

ShowPlanXml 8388608

SHOWPLAN_XML

XactAbort 2097152

XACT_ABORT

Applies to