Post reply

Query Analyzer results shows (1 row(s) affected) 3 times for sindle record delete

  • September 29, 2010 at 1:52 pm

    #229869

    In 2005 Query Analyzer when I run a single record delete from a table the results show

    (1 row(s) affected) multiple times. Can anyone explain why the results show this.

    delete from table1

    where id = 'XXX'

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

  • September 29, 2010 at 1:54 pm

    #1229309

    check for any triggers on that table.

    -- Cory

  • September 29, 2010 at 2:01 pm

    #1229313

    Ther eis a trigger that does an additiional delete and insert. That would explain this. I see the same results for updates where it shows (1 row(s) affected) then the total row(s) affected. Could this be the result of a trigger as well?

  • September 29, 2010 at 2:32 pm

    #1229336

    Yup.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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