SQL SERVER- Solution SQL Puzzle of SET ANSI_NULL
Posted by: Journey to SQL Authority with Pinal Dave,
on 28 May 2013 |
View original | Bookmarked: 0 time(s)
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 […]...