Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

SetOptions Enumeration

SQL Server 2012

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)
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.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.