set arithabort off
set ansi_warnings on
declare @i int = 1 / 0
declare @j-2 int = 1
set @j-2 = 1/0
select [@i]=@i , [@j]=@j --> yields @i = NULL, @j-2 = 1
I DID have arithabort off while having ansi_warnings on because 1 got this
-->
Msg 8134, Level 16, State 1, Line 4
Divide by zero error encountered.
Msg 8134, Level 16, State 1, Line 6
Divide by zero error encountered.
(1 row(s) affected)
AND this
-->
@i@j-2
NULL1
regards Herbert