Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
NumericRoundAbortEnabled Property
Collapse the table of content
Expand the table of content

Database.NumericRoundAbortEnabled Property

Gets or sets a Boolean property value that specifies whether the NUMERIC_ROUNDABORT database option is active.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
public bool NumericRoundAbortEnabled { get; set; }

Property Value

Type: System.Boolean
A Boolean value that specifies whether there is a loss of precision due to rounding in an expression causes an error. If True, an error is generated and no results are returned. If False (default), a warning is generated and a NULL is returned.

Implements

IDatabaseOptions.NumericRoundAbortEnabled

This option can also be changed by using the Transact-SQL ALTER DATABASE statement.

Community Additions

ADD
Show:
© 2015 Microsoft