Finding the last table update SQL Server v 7.0


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Finding the last table update SQL Server v 7.0

  1. #1
    John Guest

    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
    Thank you,

  2. #2
    AC Guest

    Re: Finding the last table update SQL Server v 7.0


    Hi John,

    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.

    AC

    "John" <JohnVann@aol.com> wrote:
    >
    >How can I determine the last update to a table in SQL Ser. 7.0
    >Thank you,



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center