Creare un trigger.

[iif]

Ciao a tutto il forum.
Ho due tabelle identiche in due db diversi.
Vorrei che se aggiorno o aggiungo record su una tabella venisse aggiornata l'altra.
Come posso fare?
Grazie in anticipo.

[goldfix_1]

ciaooo

/*TRIGER INSERT*/
CREATE TRIGGER trigger_name_INS
ON NOME_TBL
FOR INSERT AS

INSERT Tbl_DEST (Col1, Col2)
VALUES (SELECT FROM INSERTED Col1, Col2)

/*TRIGER UPDATE*/
CREATE TRIGGER trigger_name_UPD
ON NOME_TBL
FOR UPDATE AS

UPDATE Tbl_DEST
Set Tbl_DEST.Col1 = I.Col1
Tbl_DEST.Col2 = I.Col2
FROM Tbl_DEST
INNER JOIN (SELECT FROM INSERTED Col1, Col2) as I ON I.Col1 = Tbl_DEST.Col1

volendo la cosa si puo' fare anche con un solo trigerino....
ecco uno idea...

CREATE TRIGGER trigger_name_INS
ON NOME_TBL
FOR INSERT

SELECT Col1, Col2
FROM Tbl_DEST
WHERE Col1 IN
(
SELECT Col1 FROM INSERTED
)

IF (select @@RowCount)=1
begin
UPDATE Tbl_DEST
Set Tbl_DEST.Col1 = I.Col1
Tbl_DEST.Col2 = I.Col2
FROM Tbl_DEST
INNER JOIN (SELECT FROM INSERTED Col1, Col2) as I ON I.Col1 = Tbl_DEST.Col1
end
else
begin
INSERT Tbl_DEST (Col1, Col2)
VALUES (SELECT FROM INSERTED Col1, Col2)
end


ciaoooo

[iif]

corbezzoli!
Grazie.