TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

SetOptions Enumeration

 

Specifies the various types of predicate SET options found in SQL.

Namespace:   Microsoft.SqlServer.TransactSql.ScriptDom
Assembly:  Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)

[SerializableAttribute]
[FlagsAttribute]
public enum class SetOptions

Member nameDescription
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.

Return to top
Show:
© 2016 Microsoft