Don't know how to create simple trigger

[ckevin]

Hi all, I am a new guy for MS SQL server, and I have a question on how to create a trigger.

I have one table PO, there are 4 columns: rowid, creater, modifier and PO_detail

What I want to do is to check out all the modification did by user "ELLEN" during last week. (12/8 - 12/12). Of course, it is update statement and his name are recorded at "modifier" column.

Just wondering what's the best way to do so.

Thank you very much

Best regard,
Kevin Chan

 

[Mdavis123]

Hi Kevin,

Using an Insert or Update trigger, you query the Fake Table called "Inserted" to get the info you wish.

Declare @Modifiedby varchar(50)
Select @Modifiedby =modifier from inserted
If @Modifiedby = "Ellen"
--Do something

Happy Hollidays
MikeD

 

[ckevin]

Thank you very much, It works