Previous Topic

Next Topic

Inhoudsopgave

Book Index

Cases with X <> NULL

/* 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