On a query is ended when an overflow or divide - by - zero error occurs during query execution 在查询执行过程中出现溢出或被零除等错误时,结束查询。
No warnings are raised and null values are returned when conditions such as divide - by - zero occur 出现被零除等情况时不会引发警告,而是返回空值。
The following example demonstrates the divide - by - zero and overflow errors that have both set arithabort settings 设置下的被零除错误和溢出错误。
Keyword . in this example , a method tests for a division by zero , and catches the error 此示例中使用一个方法检测是否有被零除的情况;如果有,则捕获该错误。
Controls whether error messages are returned from overflow or divide - by - zero errors during a query 控制在查询执行过程中,是否返回溢出或被零除错误的错误消息。
When set to off , the divide - by - zero and arithmetic overflow errors cause null values to be returned 设置为off时,被零除错误和算术溢出错误将导致返回空值。如果在
For example , to avoid a division by zero in the calculation of the sine function you could write either the following 例如,为在sine函数的计算中避免被零除,可编写为:
Option causes the compiler to check all integer calculations for errors such as overflow or division by zero 选项使编译器检查所有整数计算中是否存在诸如溢出或被零除这类错误。
Errors or warnings are issued when conditions such as divide - by - zero occur or null values appear in aggregate functions 当出现被零除的情况或聚合函数中出现空值时,将发出错误或警告。
Set arithabort on if an overflow or divide - by - zero error occurs during query execution , the query or batch will be terminated 如果在执行查询时出现溢出或被零除错误,将终止该查询或批处理。