Share via

SetOptions Enum

  • Reference

Definition

Namespace:
Microsoft.SqlServer.TransactSql.ScriptDom
Assembly:
Microsoft.SqlServer.TransactSql.ScriptDom.dll
Package:
Microsoft.SqlServer.DacFx.x64 v140.3881.1
Package:
Microsoft.SqlServer.DacFx v150.5282.3
Package:
Microsoft.SqlServer.DacFx v160.6161.0
Package:
Microsoft.Data.Tools.Msbuild v10.0.61804.210
Package:
Microsoft.SqlServer.TransactSql.ScriptDom v161.8901.0

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
Enum
SetOptions
Attributes
FlagsAttribute SerializableAttribute

Fields

Name Value Description
None 0

None
QuotedIdentifier 1

QUOTED_IDENTIFIER
ConcatNullYieldsNull 2

CONCAT_NULL_YIELDS_NULL
CursorCloseOnCommit 4

CURSOR_CLOSE_ON_COMMIT
ArithAbort 8

ARITHABORT
ArithIgnore 16

ARITHIGNORE
FmtOnly 32

FMTONLY
NoCount 64

NOCOUNT
NoExec 128

NOEXEC
NumericRoundAbort 256

NUMERIC_ROUNDABORT
ParseOnly 512

PARSEONLY
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
ForcePlan 65536

FORCEPLAN
ShowPlanAll 131072

SHOWPLAN_ALL
ShowPlanText 262144

SHOWPLAN_TEXT
ImplicitTransactions 524288

IMPLICIT_TRANSACTIONS
RemoteProcTransactions 1048576

REMOTE_PROC_TRANSACTIONS
XactAbort 2097152

XACT_ABORT
DisableDefCnstChk 4194304

DISABLE_DEF_CNST_CHK
ShowPlanXml 8388608

SHOWPLAN_XML
NoBrowsetable 16777216

NO_BROWSETABLE

Applies to