Home Forums SQL Server 2005 Administering trigger RE: trigger
river1
SSC-Insane
Points: 24302
More actions
October 30, 2012 at 8:52 am
#1554203
like this:
update
contribuintes
set
nif = c.nif
from
contribuintes c
join
deleted d
on
d.nif_antigo = c.nif_antigo
where
c.numeroposto = 'Central'