aaronss@the-mdu.com (Simon) wrote in message news:<f526ea06.0308270235.620f795@posting.google.com>...
> 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

aaronss@the-mdu.com (Simon) wrote in message news:<f526ea06.0308270235.620f795@posting.google.com>...
> 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

"Simon" <aaronss@the-mdu.com> wrote in message
news:f526ea06.0308270235.620f795@posting.google.com...
> 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

"Simon Aarons" <aaronss@the-mdu.com> wrote in message
news:3f4c96d1$0$62079$75868355@news.frii.net...
> That's fine for specific columns which might be updated, but how is it
> that you specify for all columns and insert the old data into the audit
> table.
>
> Simon
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!