September 11, 2013 at 1:56 pm
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
September 12, 2013 at 9:37 am
Hugo Kornelis (9/9/2013)
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.
September 16, 2013 at 9:29 am
Revenant (9/10/2013)
I am glad I got to answer this one after it was corrected. 😉
Ditto
September 24, 2013 at 6:30 am
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.
Viewing 4 posts - 31 through 33 (of 33 total)
You must be logged in to reply to this topic. Login to reply