ISNULL

Question

Post reply

ISNULL

Lokesh Vij

SSChampion

Points: 10836
More actions
August 7, 2012 at 8:05 pm

#262440

Comments posted to this topic are about the item ISNULL
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
August 8, 2012 at 4:01 am

This was removed by the editor as SPAM

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

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Back to the basics .. nice question

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Michael Riemer SSCertifiable Points: 5190 More actions · Answer 2

Was really looking for what is the catch!!! 😛

Nice simple question as follow up to yesterdays... Thanks

Divine Flame SSCoach Points: 15943 More actions · Answer 3

Divine Flame

SSCoach

Points: 15943

August 8, 2012 at 1:11 am

#1522975

Too easy for QoD! 🙂 Thanks.

Sujeet Singh

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

Spent 15 minutes looking for the gotcha... (what do you want, after yesterday's question)

😀

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

Robin Sasson Hall of Fame Points: 3359 More actions · Answer 5

Nice back to basics question although I'm a bit more of a COALESCE man myself.

:exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

Toreador SSChampion Points: 11358 More actions · Answer 6

The number of wrong answers suggests spambots may be at work 😉

Rich Weissler Hall of Fame Points: 3286 More actions · Answer 7

Koen Verbeeck (8/8/2012)
Spent 15 minutes looking for the gotcha...

Gotta admit, I kept poking at it, waiting for a gotcha. Contemplated fetching my coffee before I submitted my answer even. ... but... but... it was a question I could answer before fully waking up. Thanks!

demonfox SSCertifiable Points: 6289 More actions · Answer 8

After yesterday's question , It was a feel good . 😛

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 9

(Bob Brown)

SSCrazy

Points: 2705

August 8, 2012 at 6:01 am

#1523065

Thank you for the brain break.

sestell1 SSChampion Points: 10230 More actions · Answer 10

I thought for sure this was some sort of trick question... very happy to get it right. 🙂

sestell1 SSChampion Points: 10230 More actions · Answer 11

Robin Sasson (8/8/2012)
Nice back to basics question although I'm a bit more of a COALESCE man myself.

I remember a long time ago (SQL Server 2005?) having performance issues using COALESCE rather than ISNULL, although I never really looked into it to find out what was going on. I suspect there may have been other mitigating factors.

Steve Cullen SSCertifiable Points: 5598 More actions · Answer 12

I recall in school, there were some teachers that would give a point for filling out your name on your paper correctly. I feel like I just got one of those points.

Still there was always someone iin the class that would screw that up.

Converting oxygen into carbon dioxide, since 1955.

DugyC Hall of Fame Points: 3804 More actions · Answer 13

Nice back to basics questions, nice and easy despite my insane attempts to find the catch... :crazy:

Thanks 😀

_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]