DIVIDE_BY_ZERO_ERROR option [TSQL]

Function

Controls the reporting of division by zero.

Allowed values

ON, OFF

Default

ON

Description

This option indicates whether division by zero is reported as an error. If the option is set ON, then division by zero results in an error with SQLSTATE 22012.

If the option is set OFF, division by zero is not an error. Instead, a NULL is returned.