March 26, 2014 at 10:33 pm
Comments posted to this topic are about the item What is (Null='Hello') in Sql Server
March 26, 2014 at 10:34 pm
I get the explanation for why 5 does not show up. Is that the same reason 2 also doesn't show up? My guess was 2, 4, and 5.
March 27, 2014 at 12:30 am
The answer is only correct is ANSI_NULLS is ON. With ANSI_NULLS off one obtains 2,4,5.
March 27, 2014 at 12:58 am
mikesyd (3/26/2014)
I get the explanation for why 5 does not show up. Is that the same reason 2 also doesn't show up? My guess was 2, 4, and 5.
Yes, it's the same reason. By the fact, "A <> B" and "not(A=B) are strictly identical.
March 27, 2014 at 1:09 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 27, 2014 at 2:43 am
Am I the only one who thinks that is the expected behaviour?
With default SQL settings...
You cant ask if something = null and expect to get the correct answer. So why would you expect NOT(something =null) to work?
March 27, 2014 at 3:01 am
This was removed by the editor as SPAM
March 27, 2014 at 3:41 am
danielfountain (3/27/2014)
Am I the only one who thinks that is the expected behaviour?
No. I almost guessed something different as these questions very rarely have the obvious option as the answer - particularly since the question said that this was somehow 'unusual'. But I couldn't manage to make any of the others fit, so went for the obvious choice and got it right.
March 27, 2014 at 6:14 am
Stewart "Arturius" Campbell (3/27/2014)
Interesting question with some interesting red herring answers.Thanks, Jaime
+1 on the red herring answers. Nice question.
March 27, 2014 at 7:14 am
Important to know the mechanics of null values. Thanks for the question!
Tony
------------------------------------
Are you suggesting coconuts migrate?
March 27, 2014 at 7:29 am
Nice question about a basic concept that many people don't understand. Given that at the time of post there are 30% wrong answers it seems this is something that many people need to look at.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 27, 2014 at 7:34 am
Sean Lange (3/27/2014)
Nice question about a basic concept that many people don't understand. Given that at the time of post there are 30% wrong answers it seems this is something that many people need to look at.
+1
I'm surprised how many people fear null values because they don't understand them, which is a shame as they can be quite useful once you understand their behavior.
March 27, 2014 at 7:39 am
nice question..
thanks jaime.
March 27, 2014 at 8:23 am
Intriguing question. I enjoyed it. Thanks
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 15 posts - 1 through 15 (of 36 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy