• I missed this one but nice question thanks.

    I was thinking that the row can be updated since on insert operation with trigger on it:

    first inserts the row into the table, then the row is added into the INSERTED table, then the trigger actions are executed and finally commit or rollback.

    But I missed the "updating the row in the INSERTED table" :angry: which is not possible.

    Anyway nice exercise, thanks.

    Regards,

    Iulian