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.
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs