Example SET ANSI_NULLS ON/OFF?

Question

SQL Server

Can someone give an example of using ANSI_NULLS? I understand how it works, but I don't know how it can be used, in what situation could it be useful and why?

Answer 1

In a future release, the SQL Server ANSI_NULLS setting will be set to ON, and applications that explicitly set it to OFF will raise an error. Avoid using this component in new developments and plan to change existing applications that use it.