Identify last updated record

[Savil]

Hi
If I have an update trigger on a table and the table is updated, how can I identify to the trigger the updated record that initiated the trigger?

I need to have a system that records changes to a financial database. My idea is that the trigger can insert a record into a logging table. If anyone has any other method of doing this then I would be delighted to hear them.

Thanks

 

[JackVam]

Do you mean something like :
--trigger code--
SELECT * FROM myTable where id = SCOPE_IDENTITY()

which would identify the last record inserted in that scope

All the IT jobs in one place -

http://www.ITjobfeed.com