set ANSI_NULLS Off/On
set ANSI_NULLS Off
@id = null (Good)
set ANSI_NULLS On
@id = null(Never equal)
@id is null (Always run good)
set ANSI_NULLS Off
@id = null (Good)
set ANSI_NULLS On
@id = null(Never equal)
@id is null (Always run good)