Arithignore statement in SQL Server

The Arithignore command controls whether SQL Server return null for divided by zero or any arithmetic error. 

Syntex

SET Arithignore ON/OFF

ON : SQL Server return NULL for divide by zero and overflow errors instead of raising error.

OFF: SQL Server raise an error for this arithmetic issue.

See the example.

SET ARITHABORT OFF;  SET ANSI_WARNINGS OFF  GO   PRINT 'Setting ARITHIGNORE ON';  GO  -- SET ARITHIGNORE ON and testing.  SET ARITHIGNORE ON;  GO  SELECT 1 / 0 AS DivideByZero;  GO  SELECT CAST(256 AS TINYINT) AS Overflow;  GO   PRINT 'Setting ARITHIGNORE OFF';  GO  -- SET ARITHIGNORE OFF and testing.  SET ARITHIGNORE OFF;  GO  SELECT 1 / 0 AS DivideByZero;  GO  SELECT CAST(256 AS TINYINT) AS Overflow;  GO