MS SQL Trigger to update changes in a record

[Yas]

Hello All,

I have 2 tables in a MS SQL DB. Table1 and Table2.Log

Table2.Log was a copy of Table1 + an extra column for date_deleted. I
have 2 Triggers on Table1, Insert and delete. So when a record is
inserted into Table1 it's copied onto Table2.log, and when deleted in
Table1 the same record in Table2.log is time stamped with time of
deletion.

I would like to have another Trigger on Table1 for update. So if a
certain field (not primary key) is updated for a record it is also
updated in Table2.log This way Table2.log will always have exactly the
same fields per record as Table1.

I'm not sure how to reference the modified records only and update
just the modified fields...something like...?
----------------------------
CREATE TRIGGER [tr_updateT_Log] ON [dbo].Table1
FOR UPDATE
AS
Update Table2.Log
SET description = , office =
-------------------------------------------------
Any help would be greatly appreciated

Thanks
Y

[Ed Murphy]

Yas wrote:

I would like to have another Trigger on Table1 for update. So if a
certain field (not primary key) is updated for a record it is also
updated in Table2.log This way Table2.log will always have exactly the
same fields per record as Table1.

Update triggers can reference both the 'inserted' and 'deleted'
pseudo-tables (IIRC the first contains the changed rows in their
post-change state, the second contains them in their pre- state).

[Yas]

On 12 Mar, 08:10, Ed Murphy <[e-mail]:

Yas wrote:

I would like to have another Trigger on Table1 for update. So if a
certain field (not primary key) is updated for a record it is also
updated in Table2.log This way Table2.log will always have exactly the
same fields per record as Table1.

Update triggers can reference both the 'inserted' and 'deleted'
pseudo-tables (IIRC the first contains the changed rows in their
post-change state, the second contains them in their pre- state).

Is it possible to just update the columns in a row that have been
modified and leave the others untouched?

Thanks again