Transaction rowcount

  • Comments posted to this topic are about the item Transaction rowcount

  • Nice question

    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]

  • Nice question, I liked that it is clean and straightforward, no tricks. The column names in that table of yours are not very nice though. 😀

    Oleg

  • Nice question, thanks!

  • a very good question... thanks 🙂

  • nice!! but tough to concentrate........

  • good question

  • Nice question. You got me with the last SELECT setting the value to 1. I thought it returned 0.

    "Beliefs" get in the way of learning.

  • Can anyone explain me, how does it return '1' as the last rowcount???

  • sakthi_madan,

    Run in query analyser:

    SELECT @@ROWCOUNT

    SELECT @@ROWCOUNT

    The first statement returns a row with 0

    The second statement is the count of rows returned from the first, i.e 1 row of 0.

    Hope that makes sense.

    I got the answer wrong as well... so close yet so far. Good question.

    Kev

  • Yeah thanks...

    Now i got it...

    Thanks for your reply..!!!

  • Yep. @@rowcount is a cruel mistress. I avoid her like a rash. 😀

    Converting oxygen into carbon dioxide, since 1955.
  • Nice question. Thanks.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Nice question, but, if we run the given script, don't we have an error on this line ?

    select @@rowcount-- check this one out

    EuG

  • No.. i'm not getting any error..

    are you??

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

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