Hi
I am trying to produce an update trigger. I understand the concept of
delete and insert triggers without a problem. Unfortuantely, the
update triggers do not have particularly simple documentation in BoL.
So, can someone please explain to me, quite simply how I would produce
a trigger on the following:
I have table 1 which we'll call simon. In here are various columns and
rows. I also have table 2, called simon_a, my audit table.
Whenever anything is updated or deleted in simon, I want it sent to
the simon_a table. Delete, as above, is fine since it's conceptual but
help me out on the update one. I cannot seem to figure out how to get
the information from the table before it's updated.
As ever, champagne and beer for the successful answer.
With thanks
Simon