/* Case 3: X <> NULL */
declare
@i int
= 1;
set ansi_nulls off
;
if
@i <> null
select
'True'
as
[Case 3, ansi_nulls OFF]
else
select
'FALSE'
as
[Case 3, ansi_nulls OFF];
set ansi_nulls on
;
if
@i <> null
select
'True'
as
[Case 3, ansi_nulls ON]
else
select
'FALSE'
as
[Case 3, ansi_nulls ON];
if
@i is not null
select
'True'
as
[Case 3, ansi_nulls ON, solution]
else
select
'FALSE'
as
[Case 3, ansi_nulls ON, solution];
go