relate two tables

Question

I would like to know how to relate two tables in different databases so that every time the value in the bank table1.dbo.table id1 will be changed also in the bank.dbo.table id1, modifying according to the line(id) which is being modified

the point is that the tables are like this

Tabela1
id - coluna2 - coluna3 - point
1 --- 0 ----------- 0 -------- 10
2 --- 0 ----------- 0 -------- 25

table 2
id - coluna2 - coluna3 - coluna4 - bonus
1 ------ 0 -------- 0 ---------- 0 --------- ?
2 ------ 0 -------- 0 ---------- 0 --------- ?

i wanted this point to pass pro bonus whenever it was changed, according to the row there (id), so in the case if moved that 25 there in row 2 will be changed also here in row 2 of the bonus column in table 2 is kind of confusing, thank you for responding

Answer 1

This way you must get what you want:

-- Descomentar apenas se a solução abaixo não resolver o problema
-- EXEC sp_configure 'show advanced options', 1
-- GO
-- RECONFIGURE
-- GO
-- EXEC sp_configure 'nested triggers', 0
-- GO  
-- RECONFIGURE
-- GO

-- Alterar o "MyDataBase" para o nome da base de dados
ALTER DATABASE MyDataBase SET RECURSIVE_TRIGGERS OFF
GO

CREATE TRIGGER tr_AtualizaID ON tabela1
AFTER UPDATE   
AS
    DECLARE @Id     UNIQUEIDENTIFIER
    DECLARE @Points FLOAT

    IF UPDATE(points)
    BEGIN
        SELECT  TOP 1 
                @Id     = id
            ,   @Points = points
        FROM    inserted

        UPDATE  tabela2
        SET     bonus   = @Points
            ,   origem  = 1
        WHERE   id      = @Id
    END
GO

CREATE TRIGGER tr_AtualizaID ON tabela2
AFTER UPDATE   
AS
    DECLARE @Id     UNIQUEIDENTIFIER
    DECLARE @Points FLOAT

    IF UPDATE(points)
    BEGIN
        SELECT  TOP 1 
                @Id     = id
            ,   @Points = points
        FROM    inserted

        UPDATE  tabela1
        SET     bonus   = @Points
            ,   origem  = 1
        WHERE   id      = @Id
    END
GO

The initial comments serve to, when uncommented, avoid nesting triggers, but should only use if the solution to disable the recursion does not work.