Try Catch Throw

  • jclementz

    SSC Eights!

    Points: 910

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

  • Neil Burton

    SSC-Insane

    Points: 21923

    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 [/url]

  • Mighty

    SSCrazy Eights

    Points: 8435

    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: 21923

    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 [/url]

  • Hany Helmy

    SSChampion

    Points: 13321

    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

  • michal.lisinski

    SSCertifiable

    Points: 6933

    Hi

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

    Regards

    Mike

  • Richard Warr

    SSCertifiable

    Points: 6955

    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

  • Hugo Kornelis

    SSC Guru

    Points: 64645

    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/

  • twin.devil

    SSC-Insane

    Points: 22208

    Good question. Nice share

    and good point shared by Hugo +1.

  • Ed Wagner

    SSC Guru

    Points: 286958

  • Victor Kirkpatrick

    Hall of Fame

    Points: 3672

    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

    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

  • Rich Mechaber

    SSChampion

    Points: 10935

    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