UserOptions.AbortOnArithmeticErrors Property
Gets or sets the Boolean property value that specifies whether arithmetic divide by zero errors are terminated or not.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.Deploy, _
"false")> _
Public Property AbortOnArithmeticErrors As Boolean
Get
Set
'Usage
Dim instance As UserOptions
Dim value As Boolean
value = instance.AbortOnArithmeticErrors
instance.AbortOnArithmeticErrors = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy,
"false")]
public bool AbortOnArithmeticErrors { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::Deploy,
L"false")]
public:
property bool AbortOnArithmeticErrors {
bool get ();
void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy,
"false")>]
member AbortOnArithmeticErrors : bool with get, set
function get AbortOnArithmeticErrors () : boolean
function set AbortOnArithmeticErrors (value : boolean)
Property Value
Type: System.Boolean
A Boolean value that specifies the whether a query is terminated when an arithmetic divide by zero occurs.If True, queries are terminated when an arithmetic divide by zero error occurs.If False (default), queries are not terminated when an arithmetic divide by zero error occurs; instead, a warning message is displayed and a Null value is assigned to the result of the arithmetic operation.
Examples
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace