last value updated in sql server 2000
-
Hi there, Is it possible to get the last value updated in a table after an update operation has been conducted Any help would be greatly appreciated leo Kathmandu, Nepal
-
Hi there, Is it possible to get the last value updated in a table after an update operation has been conducted Any help would be greatly appreciated leo Kathmandu, Nepal
anj1983 wrote:
Is it possible to get the last value updated in a table after an update operation has been conducted
A column of type TIMESTAMP can be used for it, because each time when a row is modified, the timestamp's value get chnged. Moreover it stores value in binary number. Alternately you can use a column of type DATETIME, and programmatically modifiy its value when updation takes place. Using this technique you trace recent update operation. Regards. _____________________________ Success is not something to wait for, its something to work for.