Try Catch Throw

Question

Post reply

Try Catch Throw

jclementz

SSC Eights!

Points: 910
More actions
May 25, 2015 at 11:43 pm

#308507

Comments posted to this topic are about the item Try Catch Throw
May 26, 2015 at 2:00 am

This was removed by the editor as SPAM
May 26, 2015 at 6:43 am

This was removed by the editor as SPAM

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

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

Neil Burton SSC-Insane Points: 22993 More actions · Answer 1

Does it say anywhere to select two answers? I only selected one answer and got it wrong because two were required?

Edited because Mighty answered the question I actually asked rather than the one I meant!

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

Mighty SSCrazy Eights Points: 9063 More actions · Answer 2

BWFC (5/26/2015)
Did I miss something when I only selected one answer and got it wrong because two were required?

Yes, the second part of the correct answer. 😀

Neil Burton SSC-Insane Points: 22993 More actions · Answer 3

Mighty (5/26/2015)
BWFC (5/26/2015)
Did I miss something when I only selected one answer and got it wrong because two were required?
Yes, the second part of the correct answer. 😀

Oh very funny 😛 I suppose I set myself up for that one really!

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

Hany Helmy SSChampion Points: 13921 More actions · Answer 4

OK, the author should have (like all other QotD) mention to select 2 answers, still it`s a very good question.

Thanx.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

michal.lisinski SSCertifiable Points: 6933 More actions · Answer 5

Hi

Pretty cool QotD, I had to think twice before mark correct answers. 😎

Regards

Mike

Richard Warr SSCertifiable Points: 6966 More actions · Answer 6

Hany Helmy (5/26/2015)
OK, the author should have (like all other QotD) mention to select 2 answers, still it`s a very good question.
Thanx.

The question featured checkboxes rather than radio buttons and there were clearly two distinct elements to the answer, one about the transaction and one about the error.

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 7

BWFC (5/26/2015)
Does it say anywhere to select two answers?

I wondered about that myself, when I saw the two sets of three mutually exclusive options each.

Previously, I have submitted questions with multiple answers and deliberately not mentioned the number of correct answers (because that would be a hint I did not want to provide). And then was disappointed to see that number being added (by the site's program? the editor? faeries?) when the question went live.

It looks like that process is now no longer in place, and it is left to the question author to decide whether or not to tell the reader how many answers are correct.

(Note that you can still see from the use of tickboxes that there is more than one correct answer)

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Umer Akram SSC-Insane Points: 22209 More actions · Answer 8

Good question. Nice share

and good point shared by Hugo +1.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 9

Nice question, thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Victor Kirkpatrick Hall of Fame Points: 3672 More actions · Answer 10

Deferred Name Resolution is an awful "feature". At the very least it should be optional/configurable. I want to always know that my proc is being compiled referencing a table that does not exist! We only get to find out it fails at run time, which is not the time.

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 11

I have selected two answers thinking that author gave the check boxes to select more than one answer.

nice question.. got it rite 🙂

Rich Mechaber SSChampion Points: 11130 More actions · Answer 12

Great question. Note that the outcome is dependent on the setting of XACT_ABORT. The default is OFF, but if set to ON, the transaction will rollback, and executing the SP will return one error instead of two.

Here's a link with more info: https://www.simple-talk.com/sql/t-sql-programming/defensive-error-handling/[/url]

Rich