How to Track When a Record Gets Updated

[OldNapkin]

I'd like to be able to automatically store the date and time that a record gets
updated. I currently stamp the record when it's first created by having a field
with a default value of GETDATE(), but I can't seem to find an easy way to
track the updates.

Thanks!

[jdeline]

Why not create a field that contains the latest update date?

[OldNapkin]

I have a field - I'm looking for a function in the database to update the
field with the date and time when the record gets updated. I know I could
update it with a query from ColdFusion, but I'd like it all to just happen
automatically within the DB.

[paross1]

To expand on Dan's post....

Phil

Syntax
CREATE TRIGGER trigger_name
ON { table | view }
[ WITH ENCRYPTION ]
{
{ { FOR | AFTER | INSTEAD OF } { [ INSERT ] [ , ] [ UPDATE ] }
[ WITH APPEND ]
[ NOT FOR REPLICATION ]
AS
[ { IF UPDATE ( column )
[ { AND | OR } UPDATE ( column ) ]
[ ...n ]
| IF ( COLUMNS_UPDATED ( ) { bitwise_operator } updated_bitmask )
{ comparison_operator } column_bitmask [ ...n ]
} ]
sql_statement [ ...n ]
}
}