Yes, After changing default ansi_null setting null can evaluate with null. Check the below code for reference.
select 1 where null = null
go
set ansi_nulls off
go
select 1 where null = null
go
Loading
Yes, After changing default ansi_null setting null can evaluate with null. Check the below code for reference.
select 1 where null = null
go
set ansi_nulls off
go
select 1 where null = null
go