Export (0) Print
Expand All
Expand Minimize

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)

[SerializableAttribute]
[FlagsAttribute]
public enum SetOptions

Member nameDescription
AnsiDefaultsThe option is AnsiDefaults.
AnsiNullDfltOffThe option is AnsiNullDfltOff.
AnsiNullDfltOnThe option is AnsiNullDfltOn.
AnsiNullsThe option is AnsiNulls.
AnsiPaddingThe option is AnsiPadding.
AnsiWarningsThe option is AnsiWarnings.
ArithAbortThe option is ArithAbort.
ArithIgnoreThe option is ArithIgnore.
ConcatNullYieldsNullThe option is ConcatNullYieldsNull.
CursorCloseOnCommitThe option is CursorCloseOnCommit.
DisableDefCnstChkThe option is DisableDefCnstChk.
FmtOnlyThe option is FmtOnly.
ForcePlanThe option is ForcePlan.
ImplicitTransactionsThe option is ImplicitTransactions.
NoBrowsetableSuppresses metadata.
NoCountThe option is NoCount.
NoExecThe option is NoExec.
NoneThe option is None.
NumericRoundAbortThe option is NumericRoundAbort.
ParseOnlyThe option is ParseOnly.
QuotedIdentifierThe option is QuotedIdentifier.
RemoteProcTransactionsThe option is RemoteProcTransactions.
ShowPlanAllThe option is ShowPlanAll.
ShowPlanTextThe option is ShowPlanText.
ShowPlanXmlThe option is ShowPlanXml.
XactAbortThe option is XactAbort.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft