Re: MS SQL copy new and modified rows from TABLE1 to TABLE2
Posted by Roy Harvey on 08/16/07 15:48
On Thu, 16 Aug 2007 08:13:47 -0700, Yas <yasar1@gmail.com> wrote:
>> Since the tables are in the same database, triggers is definitely the
>> way to go.
>>
>
>Thanks. This is what I'm trying to do now... do you know how I can
>refer to the row that has just been added or modified?
Read up on the INSERTED and DELETED virtual tables that are available
to triggers.