|Subject||Re: On Updating One Column Value, Update Time Stamp in Another Column|
The timestamp should be updated in Col5 only when Col3 is updated and not for any other column update.
On Wednesday, 9 August 2017 2:20 PM, Vishal Tiwari <vishualsoft@...> wrote:
I have one issue to share with you.
I have one table say "MyTable", which has five columns, say Col1, Col2,...,Col5 and it has 10 rows. Col5 is of Timestamp.
My issue is, whenever I am updating Col3, that time, only for that row of Col5, Timestamp value should be updated to the current timestamp.
What would be the best option for this?
If trigger is the best way then how would I do it? As I never worked on Triggers.
Kindly let me know if my issue is not clear.
Thanks In Advance.
With Best Regards.