Finding the last table update SQL Server v 7.0
How can I determine the last update to a table in SQL Ser. 7.0
Re: Finding the last table update SQL Server v 7.0
You can write a trigger to monitor for an update of that table. The trigger
will look like:
select field_ID, some_field, other_fields,... from inserted
And then from the front-end (if you are doing something from web), you can
retrieve that recordset and show the ID value just like you retrieve any
recordset using ADO.
For other related case of inserting a record, you can use select @@identity
to retrieve ID for last inserted record.
Hope this would help.
"John" <JohnVann@aol.com> wrote:
>How can I determine the last update to a table in SQL Ser. 7.0
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center