Post reply

Last Operation on a table

  • August 4, 2008 at 5:43 am

    #126898

    Hi all

    I have done an update and INSERT operation on a table in my database.

    Is there some way, I can see how many rows affected by this operation. I lost the shots which tells you this immediately after the execution in query window

    I cant rollback the txn

  • August 4, 2008 at 7:35 am

    #852670

    SELECT @@Rowcount AS RowsAffected

  • August 4, 2008 at 8:26 am

    #852710

    Are you asking about a way to programmatically determine that, or to determine it after it's already done and over with and the code is no longer running?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 3 posts - 1 through 2 (of 2 total)

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