ISNULL

Question

Post reply

ISNULL

DonlSimpson

SSCertifiable

Points: 7043
More actions
September 20, 2014 at 11:50 am

#299604

Comments posted to this topic are about the item ISNULL
Don Simpson

I'm not sure about Heisenberg.
September 22, 2014 at 5:40 am

This was removed by the editor as SPAM

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

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

Hany Helmy SSChampion Points: 13921 More actions · Answer 1

Eazy mozo 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Vimal Lohani SSCommitted Points: 1650 More actions · Answer 2

Good one..

Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

Nice question thanks.

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

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 4

Thank you for the post, good one. (guessed the answer right also the explanation behind it)

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

TomThomson SSC Guru Points: 104773 More actions · Answer 5

TomThomson

SSC Guru

Points: 104773

September 22, 2014 at 5:08 am

#1746993

Nice simple one for the start of the week.

Tom

SqlMel SSCrazy Points: 2901 More actions · Answer 6

Good question.

I anticipate many people will go for the NULL answer.

---------------
Mel. 😎

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

SqlMel (9/22/2014)
Good question.
I anticipate many people will go for the NULL answer.

Yes they will. The concept is important, though. The presence of the row makes all the difference in the world. One might even argue the presence of rows is the start of learning to count. 😉

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

cgumprich Ten Centuries Points: 1056 More actions · Answer 8

Good question, thanks. I got the right answer for the wrong reason -- the explanation helped!

dfortier SSC-Addicted Points: 411 More actions · Answer 9

dfortier

SSC-Addicted

Points: 411

September 22, 2014 at 7:41 am

#1747073

Got me! 🙁

JustMarie SSCertifiable Points: 7771 More actions · Answer 10

Made my guess, ran the code, got back NULL. Not an empty record set - NULL.

stephen.long.1 SSCrazy Points: 2582 More actions · Answer 11

Nice, simple question - good way to get the brain working after the weekend. Thanks! 🙂

Marcia J SSCertifiable Points: 5649 More actions · Answer 12

dfortier (9/22/2014)
Got me! 🙁

Me, too. I'll blame it on a Monday morning brain.

Marcia J SSCertifiable Points: 5649 More actions · Answer 13

JustMarie (9/22/2014)
Made my guess, ran the code, got back NULL. Not an empty record set - NULL.

So, did I. Even though that's what I answered, that's not what I was expecting since the explanation made sense to me.

~~Can anyone explain why I would get something back?~~

Running 2008 R2.

Never mind. I see why. There are two select statements. The second one is doing a select on the variable @test-2 which is null. That's the one that is returning a null value.