Transaction

  • Comments posted to this topic are about the item Transaction

  • Too simple .....

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Clear and easy question! Thanks!

    🙂

  • Easy one, thanks!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Good question Sasidhar

  • Very Easy Points 🙂

  • Carlo Romagnano (10/13/2013)


    Clear and easy question! Thanks!

    🙂

    +1 🙂

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • Easy & good one. 🙂

  • I also got the answer correct but, seeing that 1/3 of respondents hadn't, clicked on "Discuss" to see if there would be something in here other than half a dozen people saying how easy they thought the question was.

    As there wasn't, it's worth noting something the question got close to; the different way COMMIT and ROLLBACK work within nested transactions and making sure we understand why this is the case.

    The discussion area gives us an opportunity to explore further some of the concepts raised by the original question in a way that might be of benefit to people coming in here having picked the incorrect answer.

    _____________________________________________________________________
    MCSA SQL Server 2012

  • Thanks for the question!

    I personally find this link more illustrative than the provided one.

    http://technet.microsoft.com/en-us/library/ms189336(v=sql.105).aspx

  • I got this right because we'd been bitten on the ar*e by this when first amending our system to work with SQLServer as well as Oracle.

  • Very easy one.

    -----------------
    Gobikannan

  • Nice question.

    Due to the amount of criticism of previous QOD of the phrasing of the Q'a and A's I am surprised that no one posted anything about the wording of the answer!

    It is technically incorrect as records are inserted into the table, they do not remain after the rollback.

    Since the question asks for the result of the batch (although there are several bacthes) the answer should be 'no rows returned' or '0 Row(s) affected'

    Please note I am not criticising the question or answer, just making an observation.

    Far away is close at hand in the images of elsewhere.
    Anon.

  • If one of the choices were 1,2, I might have gotten tripped up.

  • raulggonzalez (10/14/2013)


    Thanks for the question!

    I personally find this link more illustrative than the provided one.

    http://technet.microsoft.com/en-us/library/ms189336(v=sql.105).aspx

    +1.

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

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