April 9, 2014 at 10:18 pm
Comments posted to this topic are about the item Catch this!
April 9, 2014 at 11:47 pm
Good one, thanks.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 10, 2014 at 12:00 am
i caught two points 😛
April 10, 2014 at 12:04 am
Easy one...
April 10, 2014 at 12:06 am
Awesome questions, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 10, 2014 at 12:50 am
lol.. I got this by accident.. I was assuming a print function won't fail the query and didn't even notice the string is longer than 15 chars.
April 10, 2014 at 4:11 am
Good one.... with nice twist... Thank you for the post.
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
April 10, 2014 at 4:43 am
good one
April 10, 2014 at 5:25 am
pmadhavapeddi22 (4/10/2014)
good one
My compliments on the twist at the end. Thanks.
April 10, 2014 at 6:57 am
Guess I'll be the first to say that the "twist" was not appropriate. The question was titled and about the TRY...CATCH structure in SQL Server, the string length was a "Gotcha!" in an ISNULL statement.
Who cares about points though?
April 10, 2014 at 7:08 am
venoym (4/10/2014)
Guess I'll be the first to say that the "twist" was not appropriate. The question was titled and about the TRY...CATCH structure in SQL Server, the string length was a "Gotcha!" in an ISNULL statement.Who cares about points though?
If the knowledge you need to get every question right is obvious by the title, you are actually making questions easier.
My only problem with the question is that although the trick is cool, it also means people can get it right by accident, making the people who made 2 mistakes outperform those who made only one.
April 10, 2014 at 7:32 am
venoym (4/10/2014)
Guess I'll be the first to say that the "twist" was not appropriate. The question was titled and about the TRY...CATCH structure in SQL Server, the string length was a "Gotcha!" in an ISNULL statement.Who cares about points though?
I would not use your presumed approach to maintain code in the wild.
The comments at the top of a code-block may say what the code is "supposed" to do. But that does not mean I can go blindly into the code thinking that in fact is what the code is doing. I still have the responsibility to understand every line from top to bottom not just one particular section or another.
It's definitely a tricky question but at least all the information needed is provided. Congratulations to the author!
April 10, 2014 at 7:37 am
great QOTD.
thanks Auke.
April 10, 2014 at 7:58 am
Thanks Auke. This is a good question.
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
April 10, 2014 at 8:31 am
Nice and easy - thank you, Auke!
Viewing 15 posts - 1 through 15 (of 25 total)
You must be logged in to reply to this topic. Login to reply