What does NULL equal?

Question

Post reply

What does NULL equal?

Alan Burstein

SSC Guru

Points: 61141
More actions
September 10, 2017 at 2:26 am

#349110

Comments posted to this topic are about the item What does NULL equal?
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

Viewing 9 posts - 1 through 8 (of 8 total)

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

HappyGeek SSCoach Points: 18729 More actions · Answer 1

HappyGeek

SSCoach

Points: 18729

September 10, 2017 at 2:27 am

#1958859

Good question thanks Alan.

...

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

Nice question and an important point. Thanks, Alan.

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

morlindk SSCrazy Points: 2294 More actions · Answer 3

Oh, what a deceptive way to present the answer list, switching options 2 and 4, ...

Sean Lange SSC Guru Points: 286590 More actions · Answer 4

Great question Alan. I must need more coffee this morning. I knew the answer but managed to click the wrong one. :Whistling:

_______________________________________________________________

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/

Revenant SSC-Forever Points: 42467 More actions · Answer 5

Revenant

SSC-Forever

Points: 42467

September 11, 2017 at 11:28 am

#1958985

Very witty. Thanks, Alan!

George Vobr SSChampion Points: 10009 More actions · Answer 6

morlindk - Monday, September 11, 2017 12:47 AM
Oh, what a deceptive way to present the answer list, switching options 2 and 4, ...

+1
Yes same thing. I'm too hurried today with the answer and I was like blind...:crying:

Grumpy DBA SSChampion Points: 12531 More actions · Answer 7

Good question, had to run through it a couple times.

Stewart "Arturius" Campbell SSC Guru Points: 72634 More actions · Answer 8

Nice one, thanks
enjoyed the red herrings

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”