SetOptions Enumeration
Specifies the various types of predicate SET options found in SQL.
This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.
Namespace: Microsoft.SqlServer.TransactSql.ScriptDom
Assembly: Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)
Syntax
'Declaration
<SerializableAttribute> _
<FlagsAttribute> _
Public Enumeration SetOptions
'Usage
Dim instance As SetOptions
[SerializableAttribute]
[FlagsAttribute]
public enum SetOptions
[SerializableAttribute]
[FlagsAttribute]
public enum class SetOptions
[<SerializableAttribute>]
[<FlagsAttribute>]
type SetOptions
public enum SetOptions
Members
| Member name | Description | |
|---|---|---|
| AnsiDefaults | The option is AnsiDefaults. | |
| AnsiNullDfltOff | The option is AnsiNullDfltOff. | |
| AnsiNullDfltOn | The option is AnsiNullDfltOn. | |
| AnsiNulls | The option is AnsiNulls. | |
| AnsiPadding | The option is AnsiPadding. | |
| AnsiWarnings | The option is AnsiWarnings. | |
| ArithAbort | The option is ArithAbort. | |
| ArithIgnore | The option is ArithIgnore. | |
| ConcatNullYieldsNull | The option is ConcatNullYieldsNull. | |
| CursorCloseOnCommit | The option is CursorCloseOnCommit. | |
| DisableDefCnstChk | The option is DisableDefCnstChk. | |
| FmtOnly | The option is FmtOnly. | |
| ForcePlan | The option is ForcePlan. | |
| ImplicitTransactions | The option is ImplicitTransactions. | |
| NoBrowsetable | Suppresses metadata. | |
| NoCount | The option is NoCount. | |
| NoExec | The option is NoExec. | |
| None | The option is None. | |
| NumericRoundAbort | The option is NumericRoundAbort. | |
| ParseOnly | The option is ParseOnly. | |
| QuotedIdentifier | The option is QuotedIdentifier. | |
| RemoteProcTransactions | The option is RemoteProcTransactions. | |
| ShowPlanAll | The option is ShowPlanAll. | |
| ShowPlanText | The option is ShowPlanText. | |
| ShowPlanXml | The option is ShowPlanXml. | |
| XactAbort | The option is XactAbort. |