DROP TRIGGER PCCT0A
;
CREATE TRIGGER PCCT0A ON PCCV0A
INSTEAD OF UPDATE
AS
BEGIN
SET NOCOUNT ON
UPDATE PCCV0A SET
NAMN=(SELECT NAMN FROM INSERTED),
ADRESS = (SELECT ADRESS FROM INSERTED),
COADR = (SELECT COADR FROM INSERTED), 
POSTNR = (SELECT POSTNR FROM INSERTED), 
ORT = (SELECT ORT FROM INSERTED), 
HEMTEL = (SELECT HEMTEL FROM INSERTED), 
ARBTEL = (SELECT ARBTEL FROM INSERTED), 
PERSTEL = (SELECT PERSTEL FROM INSERTED), 
MOBIL = (SELECT MOBIL FROM INSERTED), 
FAX = (SELECT FAX FROM INSERTED), 
EPOSTHEM = (SELECT EPOSTHEM FROM INSERTED), 
EPOSTARB = (SELECT EPOSTARB FROM INSERTED), 
MEDBSKAP = (SELECT MEDBSKAP FROM INSERTED), 
MEDBDAT = (SELECT MEDBDAT FROM INSERTED), 
NYCKKOD = (SELECT NYCKKOD FROM INSERTED), 
FOLKKOM = (SELECT FOLKKOM FROM INSERTED), 
FODKOM = (SELECT FODKOM FROM INSERTED), 
BOKOM = (SELECT BOKOM FROM INSERTED), 
AVREGORS = (SELECT AVREGORS FROM INSERTED), 
AVREGDAT = (SELECT AVREGDAT FROM INSERTED), 
ADRSKYDD = (SELECT ADRSKYDD FROM INSERTED), 
HEMLIGTFN = (SELECT HEMLIGTFN FROM INSERTED), 
UPDDAT = (SELECT UPDDAT FROM INSERTED), 
UPDSIGN = (SELECT UPDSIGN FROM INSERTED), 
MODMAL = (SELECT MODMAL FROM INSERTED), 
KOMSPRAK = (SELECT KOMSPRAK FROM INSERTED), 
FODDAT = (SELECT FODDAT FROM INSERTED), 
KON = (SELECT KON FROM INSERTED), 
ADRSPRAK = (SELECT ADRSPRAK FROM INSERTED), 
FONETNAMN = (SELECT FONETNAMN FROM INSERTED), 
YRKE = (SELECT YRKE FROM INSERTED), 
SMEKNAMN = (SELECT SMEKNAMN FROM INSERTED), 
UTL_ADR = (SELECT UTL_ADR FROM INSERTED), 
UTL_POSTADR = (SELECT UTL_POSTADR FROM INSERTED), 
UTL_ADRLAND = (SELECT UTL_ADRLAND FROM INSERTED), 
TIDKOMM = (SELECT TIDKOMM FROM INSERTED), 
GRUPP = (SELECT GRUPP FROM INSERTED), 
EGENCIVKOD = (SELECT EGENCIVKOD FROM INSERTED), 
EJAVIS = (SELECT EJAVIS FROM INSERTED), 
SAKNBOST = (SELECT SAKNBOST FROM INSERTED), 
AVLDAT = (SELECT AVLDAT FROM INSERTED), 
CIVKOD = (SELECT CIVKOD FROM INSERTED), 
CIVDAT = (SELECT CIVDAT FROM INSERTED), 
SPRAKTEXT = (SELECT SPRAKTEXT FROM INSERTED), 
LANDTEXT = (SELECT LANDTEXT FROM INSERTED), 
ADRESSDAT = (SELECT ADRESSDAT FROM INSERTED), 
UTLANDTEXT = (SELECT UTLANDTEXT FROM INSERTED) 
WHERE PNR = (SELECT PNR FROM INSERTED)
END
;