:::: MENU ::::

Numeric Round-Abort (NUMERIC_ROUNDABORT) in SQL Server

  • Nov 05 / 2008
  • 0
DBA Interview questions, dbDigger

Numeric Round-Abort (NUMERIC_ROUNDABORT) in SQL Server

The Numeric Round-Abort determines the behavior when an operation results in a loss of precision. When set to TRUE in SQL Server Management Studio or ON when using the ALTER DATABASE command, an error is generated when loss of precision occurs in an expression.

When set to FALSE, losses of precision do not generate error messages and the results are rounded to the precision of the column or variable storing the result.

Consult us to explore the Databases. Contact us