Last post Nov 22, 2016 02:30 PM by Chris Zhao
Nov 17, 2016 11:27 AM|tareq.tareq|LINK
hi for ALL
i have database which have name TEST1,this database have one abc table with tow column ID and Name and i have TEST2 database which have same table
i want make trigger to send data when
abc table in TEST1 to
abc table in
please help my!!!!
Nov 18, 2016 03:10 AM|wmec|LINK
Here is example for you
SET Description = t2.Description
FROM db1.dbo.foo t1
JOIN db2.dbo.foo t2
ON t1.ItemID = t2.ItemID
to do within your trigger.
Nov 22, 2016 02:30 PM|Chris Zhao|LINK
-- UPDATE trigger on "dbo.Table1"
CREATE TRIGGER Table1Updated
ON dbo.table1 FOR UPDATE
-- update table2, using the same rows as were updated in table1
SET t2.Column = 'something'
FROM dbo.Table2 t2
INNER JOIN Inserted i ON t2.ID = i.ID