Update Trigger Syntax

[btturner]

The following TRIGGER is firing and UPDATING "ALL" rows my table. How can I modify the SQL UPDATE portion to ONLY update the row being UPDATED?

create trigger trgu_Customer on Customer for update as
begin
if update (Telephone_Number)
update Customer set touchdate = (select getdate())
end

thx in advance..

 

[swampBoogie]

I assume that the customer table have some unique column e.g. customerid.

create trigger trgu_Customer on Customer for update as
begin
 if update (Telephone_Number)
  update Customer set touchdate = getdate()
   where customerid in (select customerid from inserted)
end

The inserted table contains all rows that are affected by the query.

 

[SQLSister]

This must be trigger day, I just answered this exact question. See the trigger below for an example, it does assume you have some kind of identifying field (in this case called RecordID) in the table:

Create Trigger Update_Dates
On Table1
For Update
AS
Update Table1
set Update_Date = GetDate()
from Table1, inserted
where table1.REcordID = inserted.RecordID