Hi all,
I've got this trigger that i've somehow thumbled together.
I wanted to update a field called "Lastupdated" with the current date which it does do, but it's updating every record in the table. i'm not sure how to tell it to only update the particular row and not all of them
help!!
Thanks Dave
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER trig_updateQ1ans
ON tbl_Question1Answers
FOR UPDATE
AS
IF NOT UPDATE(questionAns)
BEGIN
RETURN
END
UPDATE tbl_Question1Answers set lastupdated = getdate()
GO