TSQL – Equivalent of On Update CURRENT_TIMESTAMP(MYSQL)

Requires a trigger in MS-SQL to achieve the same behaviour.

Update a timestamp only when a field changes (colTest).

 


A persistent field is required as S.colTest is NULL as this trigger is executed.