What is (Null='Hello') in Sql Server

Question

What is (Null='Hello') in Sql Server

JaimePC

SSC Eights!

Points: 864
More actions
March 26, 2014 at 10:33 pm

#287038

Comments posted to this topic are about the item What is (Null='Hello') in Sql Server
March 27, 2014 at 3:01 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 36 total)

You must be logged in to reply to this topic. Login to reply

HeliMan SSC Journeyman Points: 99 More actions · Answer 1

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.

There is only one truth

Andreas P. Williams SSCrazy Points: 2487 More actions · Answer 2

The answer is only correct is ANSI_NULLS is ON. With ANSI_NULLS off one obtains 2,4,5.

Roland C Hall of Fame Points: 3473 More actions · Answer 3

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.

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 4

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

BrainDonor SSCoach Points: 19259 More actions · Answer 5

An interesting question but I do think it should specify the ANSI_NULLS setting, as the answer depends upon that.

Steve Hall
Linkedin
Blog Site

danielfountain SSCarpal Tunnel Points: 4447 More actions · Answer 6

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?

Toreador SSChampion Points: 11375 More actions · Answer 7

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.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 8

Stewart "Arturius" Campbell (3/27/2014)
Interesting question with some interesting red herring answers.
Thanks, Jaime

+1 on the red herring answers. Nice question.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

tabinsc SSCommitted Points: 1812 More actions · Answer 9

Important to know the mechanics of null values. Thanks for the question!

Tony
------------------------------------
Are you suggesting coconuts migrate?

Sean Lange SSC Guru Points: 286602 More actions · Answer 10

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/

sestell1 SSChampion Points: 10230 More actions · Answer 11

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.

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 12

PChiragS

SSCarpal Tunnel

Points: 4965

March 27, 2014 at 7:39 am

#1700675

nice question..

thanks jaime.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

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