SetOptions 枚举

定义

命名空间:
Microsoft.SqlServer.TransactSql.ScriptDom
程序集:
Microsoft.SqlServer.TransactSql.ScriptDom.dll
包:
Microsoft.SqlServer.DacFx.x64 v140.3881.1
包:
Microsoft.SqlServer.DacFx v150.5282.3
包:
Microsoft.SqlServer.DacFx v160.6161.0
包:
Microsoft.Data.Tools.Msbuild v10.0.61804.210
包:
Microsoft.SqlServer.TransactSql.ScriptDom v161.8901.0

SQL 中找到的各种谓词 SET 选项。

此枚举支持其成员值的按位组合。

[System.Flags]
[System.Serializable]
public enum SetOptions
[<System.Flags>]
[<System.Serializable>]
type SetOptions = 
Public Enum SetOptions
继承
Enum
SetOptions
属性
FlagsAttribute SerializableAttribute

字段

名称 值 说明
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

禁用默认约束检查
ShowPlanXml 8388608

SHOWPLAN_XML
NoBrowsetable 16777216

NO_BROWSETABLE

适用于