n0t3p0ng4sn3rvI0z0

CREATE TRIGGER tr_ex_soci ON SOCIS AFTER DELETE AS
BEGIN
INSERT INTO ANTICS(PER_DNI,PER_TIP,PER_NOM,PER_COG,PER_ADRE,PER_TELF)
SELECT PER_DNI, 'SOCI',PER_NOM, PER_COG, PER_ADRE, PER_TELF
FROM deleted
END


DELETE FROM SOCIS
WHERE PER_DNI = '35566987D'