The code:
update
contribuintes
set
nif = c.nif
from
contribuintes c
join
inserted i
on
i.nif_antigo = c.nif_antigo
where
i.numeroposto = 'Central'
Has a problem.
I want that If the value from NIF is changed, then it needs to get back to the original value again.
So, why use the inserted instead of the deleted table?