if (null <> null)
select 'not equal'
else
select 'equal'

if (null = null)
select 'equal'
else
select 'not equal'