I have a job interview they asked me what is the difference between is null and = null in sql
for example,
select * from emp where comm = null
OR
select * from emp where comm is null
in SQL Server if we set SET ANSI_NULLS ON the COMM =NULL does not show any result, can any one explain this, thanks
What I have tried:
I said when we are working in SQL so we have to use SET ANSI_NULLS OFF, and they asked me so what is the reason they set ANSI_NULLS ON, I do not have any answer about this,