Post reply

Transaction

  • October 12, 2013 at 11:57 am

    #299640

    Comments posted to this topic are about the item Transaction

  • October 12, 2013 at 4:30 pm

    #1658095

    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]

  • October 13, 2013 at 10:34 am

    #1658133

    Clear and easy question! Thanks!

    🙂

  • October 13, 2013 at 1:39 pm

    #1658139

    Easy one, thanks!

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

  • October 13, 2013 at 10:53 pm

    #1658163

    Good question Sasidhar

  • October 13, 2013 at 11:08 pm

    #1658164

    Very Easy Points 🙂

  • October 13, 2013 at 11:35 pm

    #1658166

    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/

  • October 14, 2013 at 12:57 am

    #1658172

    Easy & good one. 🙂

  • October 14, 2013 at 2:49 am

    #1658200

    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

  • October 14, 2013 at 3:13 am

    #1658209

    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

  • October 14, 2013 at 3:47 am

    #1658221

    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.

  • October 14, 2013 at 4:30 am

    #1658225

    Very easy one.

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

  • October 14, 2013 at 6:01 am

    #1658248

    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.

  • October 14, 2013 at 6:16 am

    #1658249

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

  • October 14, 2013 at 6:36 am

    #1658254

    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 47 total)

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