ISNULL

Question

Post reply

ISNULL

Viewing 15 posts - 16 through 30 (of 39 total)

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

Mike Is Here Hall of Fame Points: 3348 More actions · Answer 1

So simple it was scary.... Where is the catch, the typo, the misguided reference?

Thanks for the question.

Rob Schripsema SSCertifiable Points: 7469 More actions · Answer 2

Koen Verbeeck (8/8/2012)
Spent 15 minutes looking for the gotcha... (what do you want, after yesterday's question)
😀

Same here.

Rob Schripsema
Propack, Inc.

Stuart Davies SSCoach Points: 19505 More actions · Answer 3

Nice straight forwards QOTD - thanks

-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Hmmmm - where's the gotcha?

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

Dana Medley SSCertifiable Points: 6764 More actions · Answer 5

This question was easy. (Yeah, a little too easy) Surely, there was something I was missing, but after much contemplation there was nothing I could see that was a catch. Thanks for the question, I needed it today. 😀

Everything is awesome!

mtassin SSC-Insane Points: 23099 More actions · Answer 6

Koen Verbeeck (8/8/2012)
Spent 15 minutes looking for the gotcha... (what do you want, after yesterday's question)
😀

/agree I was starting to get paranoid.... finally gave up and went with my gut answer.

Glad I got it right 🙂

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]

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

Revenant

SSC-Forever

Points: 42467

August 8, 2012 at 11:55 am

#1523304

Thanks for an easy one!

Narud SSCrazy Points: 2837 More actions · Answer 8

After many years working in IT, I have learned that nothing is as simple as it looks at first sight, and 1+1 not always gives 2 as result (altough should do). Fortunatelly today this wasn't the case, and the expected result also was the right answer 😎

Michael Poppers SSCrazy Points: 2151 More actions · Answer 9

Like many of you, I found this QotD [too] easy to answer. Perhaps it would have been a bit more challenging if an answer choice was "Error" :hehe:.

lulu_lutz SSCrazy Points: 2155 More actions · Answer 10

Boosted my self-esteem after yesterday's question! :w00t:

Dana Medley SSCertifiable Points: 6764 More actions · Answer 11

Michael Poppers (8/8/2012)
Like many of you, I found this QotD [too] easy to answer. Perhaps it would have been a bit more challenging if an answer choice was "Error" :hehe:.

That would've made it even worse! I probably would've spent half an hour staring at it and then another half an hour letting it sit in the back of my mind and toggling radio buttons before answering. 😛

Everything is awesome!

EL Jerry SSCertifiable Points: 7063 More actions · Answer 12

Real easy question that I had to read over and over looking for the catch. Glad there was none.

"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan

To better understand your help request, please follow these best practices.[/url]

Ken SSCoach Points: 17191 More actions · Answer 13

I was expecting to somehow get this one wrong and then be irritated with a false reason for why I was incorrect. Thankfully, there were no tricks! Thanks for the simple question.

Ken Hiatt SSC-Addicted Points: 469 More actions · Answer 14

I too was looking for the catch. So I looked up the command in the help, just to make sure I wasn't forgetting about something obscure. Nothing weird, so I opened a query window in SQL 2005 and pasted it in. Still not believing it was that simple, I clicked Execute and got an error message stating that it couldn't find the stored procedure ISNULL. WTF There is a catch, but what is it!

After I cleared the line and re-entered it, it responded with the correct answer of 1.

What! I redid the original Paste, but it only responds with the correct answer. I really wanted to paste the error here, but I can't get it to repeat.

God I love computers!

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 15

Ken Hiatt (8/8/2012)
Still not believing it was that simple, I clicked Execute and got an error message stating that it couldn't find the stored procedure ISNULL. WTF There is a catch, but what is it!

My guess: you had just the ISNULL part of the command selected (maybe you copy/pasted it to search Booke Online??) when you clicked Execute. If you click Execute while a part of the edit window is selected, only the selected text is sent to SQL Server for execution. This can be very handy when done ono purpose, or very confusing when done by accident! 😉

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/