h.tobisch (8/24/2016)

---

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