Identity of an Updated Record

[Jody]

Does anyone know how to get the indentity of the last updated record in a table. I need it for a cascading trigger.

Thank you,

Jody

[Ray Miao]

Try 'select @@identity'.


------------
Jody at 11/15/2001 10:25:06 PM

Does anyone know how to get the indentity of the last updated record in a table. I need it for a cascading trigger.

Thank you,

Jody

[Jody]

No. That gives me the identity of the last record added in the table. I need to know who is updated every time the table is changed.

j


------------
Ray Miao at 11/16/2001 9:30:47 AM

Try 'select @@identity'.


------------
Jody at 11/15/2001 10:25:06 PM

Does anyone know how to get the indentity of the last updated record in a table. I need it for a cascading trigger.

Thank you,

Jody

[David Westmore]

I'm not absolutely certain that I understand your situation, but I think that what you should be doing is to look at the "inserted" virtual table inside the trigger.

This can be used for any INSERT or UPDATE trigger to control the exact contents of any field in the inserted or updated record. THe only doubt I have is how an identity field works (the problem is that while you are in the trigger, I think you are still in a state which is prior to the commit of the transaction)...

There is also a "deleted" virtual table you can use to look at the record BEFORE the update (e.g. if you need to detect whethere particular fields have been changed).

SQL2000 can do cascading updates automatically (like Access), although obviously within a trigger you can have much more control over the whole process.

Regards

David Westmore



------------
Jody at 11/15/2001 10:25:06 PM

Does anyone know how to get the indentity of the last updated record in a table. I need it for a cascading trigger.

Thank you,

Jody