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.