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

	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.