Update trigger

[EM1107]

I have created the following trigger to update the date field in my table. The problem I have is that when I update one row it update all the rows.

What I am doing wrong?


CREATE TRIGGER NEW_GETDATE1
ON dbo.PROFILE
FOR update
AS

DECLARE @MYDATE DATETIME

SELECT @MYDATE = (GETDATE())
UPDATE dbo.PROFILE
SET DOCUMENT_DATE = @MYDATE

GO

 

[MonsterBuck]

You are forgeting to join the inserted table to your profile table.

 

[EM1107]

What do you mean?

The document_date is a column of the Profile table.

Are you proposing that I do a Join of the table on it self?

 

[SQLSister]

The reason why you need to join to the inserted table is so that you only update the records which were updated. Assuming your primary key is ProfileId you would do something like this:

UPDATE dbo.PROFILE
SET DOCUMENT_DATE = @MYDATE
From inserted i
Where Profile.ProfileID = i.ProfileID