Home Forums SQL Server 2005 T-SQL (SS2K5) After Update trigger does not catch all updated columns RE: After Update trigger does not catch all updated columns

  • pgomes (2/10/2009)


    My question is: how many rows are created in the inserted and deleted tables for a script like above that update more than one column, for the same primary key in the host table?

    The number of rows is unrelated to the number of columns. There will be one row in the inserted table and one row in the deleted table for every row that is updated. Columns have nothing to do with it.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]