Trigger for time stamp

[jldavis5]

Can someone show me a trigger that would insert a timestamp into a column of a record everytime that record was changed? Something like a last updated trigger.

 

[tlbroadbent]

Example:

CREATE TRIGGER rec_updated
ON MyTable
FOR INSERT, UPDATE
AS

set nocount on

Update MyTable
Set UpdtDatetime=getdate()
From MyTable
Join inserted
-- join assumes that a unique column
-- names RecId exists on the table
On MyTable.RecID=inserted.RecId

set nocount off
Go Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com

 

[jldavis5]

Thanks that did it