dean.giberson 64357 (9/17/2012)
I have a question that I thought I knew the answer to but I am now not sure. When in a trigger, suppose there are 10 rows in the inserted table. 3 rows have one column(call it A) updated and 7 rows have another column (call it B) updated. If code is entered in the trigger that states If Updated(A) begin ... end will the actions between the begin and end be executed on all 10 rows or only the 3 with the column A updated?
In a single insert or update of all 10 rows for the above, all 10 rows will respond to the IF UPDATED(A) because IF UPDATED() simply checks to see if anything in the whole column for the whole statement was affected.
--Jeff Moden
Change is inevitable... Change for the better is not.