Vinay Talapaneni
Will null evaluate with null(null = null)

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

By Vinay Talapaneni in SQL Server on Aug 31 2020
  • Nisha Regil
    Sep, 2020 14

    the result of null = null is not true but unknown. null is not equal ( = ) to anything—not even to another null

    • 0

Most Popular Job Functions


MOST LIKED QUESTIONS