Earlier I have posted a puzzle which received so many valid responses and got a fantastic explanation to the questions as well. I encourage all of you to read the original puzzle here. First run following script: SET ANSI_NULLS ON; — Query1 SELECT ‘SQLAuthority’ AS Statement11 WHERE ‘Authority’ IN (‘S’,’Q’, ‘L’, ‘Authority’, NULL); — Query … Continue reading SQL SERVER- Solution – SQL Puzzle of SET ANSI_NULL