Try Catch Throw

  • Comments posted to this topic are about the item Try Catch Throw

  • 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

  • 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. ๐Ÿ˜€

  • 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

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

    Thanx.

  • This was removed by the editor as SPAM

  • Hi

    Pretty cool QotD, I had to think twice before mark correct answers. ๐Ÿ˜Ž

    Regards

    Mike

  • 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.

    _____________________________________________________________________
    MCSA SQL Server 2012

  • 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/

  • Good question. Nice share

    and good point shared by Hugo +1.

  • 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.

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

    nice question.. got it rite ๐Ÿ™‚

  • This was removed by the editor as SPAM

  • 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

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

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