Database.NumericRoundAbortEnabled Database.NumericRoundAbortEnabled Database.NumericRoundAbortEnabled Property


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

 property bool NumericRoundAbortEnabled { bool get(); void set(bool value); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcProperty(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Standalone | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.SqlAzureDatabase | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Design)]
public bool NumericRoundAbortEnabled { get; set; }
Public Property NumericRoundAbortEnabled As Boolean
Property Value

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.



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

Applies to