Update trigger 1

[Delphin]

I am off to learning triggers and the first one I am having an issue with. If I update 1 row, this works fine, however if I update more than one row only the last row updates. How do I get this to update all of the rows that were affected?

CREATE trigger TimeRetrieve
on trig
for update
as
if update (update1)
begin
declare @PK as int
select @PK = ID from inserted
update trig set times = getdate() where ID = @PK
end

Billy Ballard

For in the past, Lies the future.

 

[dmhirsch]

Your @PK variable can only be filled with a single ID value. Try this:
if update (update1)
begin
update trig set times = getdate() from trig, inserted i where trig.ID = i.ID
end

 

[Delphin]

Thank you very much. I have so much to learn

Billy Ballard

For in the past, Lies the future.

 

[dmhirsch]

No problem. We all do!

David Hirsch