Results 1 to 2 of 2

Thread: query

  1. #1
    Join Date
    Aug 2006
    Posts
    1

    Unanswered: query

    Is there any way of listing all the rows which are updated after a certain time.

    Note: no date or time related column is there in the table.

    Thanks,
    Chandan Sharma

  2. #2
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    If adding a datetime stamp column to the table is not an option
    create the "on update" trigger and store the info with the time stamp in a separate table

    Cheers

    Artem

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •