dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


Tip of the Day
Language: SQL Server
Expertise: Beginner
Aug 3, 1999

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


Displaying the Timestamp in SQL Server 7

Question:
I want to show my users when a record was last updated. Is there any way to display the timestamp field?

Answer:
The timestamp field is not a good demonstration of this function.

You should approach auditing table changes by either creating a new column called DateLastModified and putting a datetime in it with username, which will give you a "last touched" record. Alternatively, you could build mirrors of your transaction tables and just log the changes in there.

By the way, doing this once is enough. There is no need for before-and-after snapshots, as a series of "afters" will show you what you want to know. By building a separate audit table, you can know what the previous field values were before they were changed, and know who changed them