November 28, 2016 at 9:58 pm
Comments posted to this topic are about the item She's not there
November 28, 2016 at 9:59 pm
This was removed by the editor as SPAM
November 29, 2016 at 3:33 am
Thanks for the question - a nice one for Zombies. 🙂
November 29, 2016 at 6:19 am
Nice and straightforward. Thanks.
November 29, 2016 at 6:40 am
That was EYE opening - http://www.sqlservercentral.com/Forums/Skins/Classic/Images/MessageIcons/W00t.gif
I have often wondered of the (Effects?) of ANSI_NULLS, and now I have a slightly clearer understanding.
By changing SET ANSI_NULL to OFF the results for the first query are changed.
November 29, 2016 at 6:50 am
NULLs can be a problem.
November 29, 2016 at 6:50 am
Budd (11/29/2016)
That was EYE opening - http://www.sqlservercentral.com/Forums/Skins/Classic/Images/MessageIcons/W00t.gifI have often wondered of the (Effects?) of ANSI_NULLS, and now I have a slightly clearer understanding.
By changing SET ANSI_NULL to OFF the results for the first query are changed.
I tried it, you're right.
November 30, 2016 at 5:35 am
I'm glad you folks liked it. That problem occurred in a production system I developed and had me scratching my head for a while. Why did my query return no results? Until I noticed a null value in the table I used for the subquery.
(@sipas I like the Zombies too but my favourite is the Carlos Santana version)
December 2, 2016 at 4:03 am
Good question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
