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
Author
Message
Posted Wednesday, September 11, 2013 1:56 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:20 AM
Points: 2,578, Visits: 549
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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 7:52 AM
Points: 379, Visits: 1,124
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.

Ditto
Post #1495152
Posted Tuesday, September 24, 2013 6:30 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 25, 2014 10:53 PM
Points: 160, Visits: 235
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.





+1

+1
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