>>
>>Thanks for the UPDATE(column) function which I didn't know. But the question still remains - is it OK or not to UPDATE another column in the UPDATE trigger.
>>
>
>I do that in a lot of triggers - I fill in the SQL username/update datetime/ and other fields that can be automated.
>
>OTOH I am the DBA for the majority of systems I work on so I can ensure recursive triggers is off.
To be on a safe side we just need to keep this setting in mind and write the code to avoid possible recursion.
If it's not broken, fix it until it is.
My Blog