Hi All,

Is there is any command to find the last update time of the table.

regards
dsekar_nat

__________________
Regards,
dsekar_nat

No.

What you can do, is to have a column named LastUpdateTime of datatype DATETIME and then have a trigger updating this column for you whenever a row is updated.

assuming you have a time stamp (as you should) on one of the fields in your table your can select max timestamp.

The TimeStamp datatype is very badly misnamed in SQL Server. There is an alias for it called rowversion which describes its purpose much better.

The timestamp datatype does not in fact store a time in it at all; it is simply a value which is automatically incremented every time the row containing it is updated.

The value in it has no useful meaning. A typical use for it is that if you save away the timestamp value when you read a row, then compare that value to the value of the timestamp column at the time you attempt to do an update, if the values are different you can detect that the row must have been changed by somebody else before you got a chance to commit your update.

This can be a very useful form of concurrency control, but it won't tell you the time of the day, which is what the OP is looking for (I think) ...



Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

dsekar, what I do for my tables is I have 2 columns, an entry_date and change_date column, this tells me 1)when the record was created and 2) when the last modification to the record was made to adapt this to your situation you could SELECT max(entry_date), max(change_date) and then compare the 2, whichever is greater is when the last operation was preformed in your table. (Of course the entry_Date column reflects INSERT's and the chnage date reflects UPDATE's)

"The one language all programmers understand is profanity."