ANSI_NULLS property is used for comparing ANSI NULLS. By default it is ON in SQL Server. As all of us aware that, we cannot compare a NULL with another NULL. i.e. We can not equal a NULL with another NULL or not

Read More