Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase «««1234

CASE vagaries Expand / Collapse
Posted Wednesday, September 11, 2013 1:56 PM


Group: General Forum Members
Last Login: Sunday, September 6, 2015 5:37 AM
Points: 2,625, Visits: 588
The title of the question has nothing to do with the trick question with the IsNULL() function and the variable length. The question only proves that IsNull is using the variable of the first parameter.

/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
Post #1493888
Posted Thursday, September 12, 2013 9:37 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 2:03 PM
Points: 701, Visits: 1,584
Hugo Kornelis (9/9/2013)
[quote]david.gwalter (9/8/2013)
Bottom line - if you look at QotD as a way to learn, then always check the discussion on the boards!

I find this to be very true even when the answers are correct. I always learn something from you and others who amplify on the answers.

I do look at the question of the day as a way to learn. So, even when I get it wrong, I still win because I have learned something.
Post #1494252
Posted Monday, September 16, 2013 9:29 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 8:03 AM
Points: 825, Visits: 319
Revenant (9/10/2013)
I am glad I got to answer this one after it was corrected.

Post #1495152
Posted Tuesday, September 24, 2013 6:30 AM


Group: General Forum Members
Last Login: Thursday, November 19, 2015 4:04 AM
Points: 162, Visits: 257
KWymore (9/9/2013)
Miles Neale (9/9/2013)
Ross.M (9/9/2013)
Steve Jones - SSC Editor (9/9/2013)
I have updated the answers and awarded back points.

I was just about to say, don't know what everyone is talking about, the correct answer is there, I even double checked it in SSMS! Thanks Steve.

+1 Some times it pays to come late to the game.


makes at least +2

Well, in the corrected version: Interesting question!

If you set out to do something, something else must be done first.
Post #1497811
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse