Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Arithabort

0 views
Skip to first unread message

Ad van der Werf

unread,
Jun 23, 1999, 3:00:00 AM6/23/99
to
When an insert, delete or update statement encounters an divide-by-zero
during the expression evalution, SQL Server 7.0 handles these errors as if
SET ARITHABORT is ON (even when SET ARITHABORT is set to OFF), the query is
aborted.

Is it possible to force SET ARITHABORT is OFF for insert, delete or update
statements. I don't want that the query is aborts but that is returns a
NULL-value.

0 new messages