How to update a row in another sql table using triggers

Question

I am currently working on a Java Swing application. The application allows users to perform various types of transactions. I created several tables in MS SQL to store user data. The following is the problem I'm currently facing.

I have a table called "UList" that contains all the user information. This particular table also contains the “Balance” column, which will contain the user's balance. There is another table called "Deposits" in which the deposit amount will be stored.

Tables:

Ulist

╔══════╦═════════╗
║ id   ║ balance ║
╠══════╬═════════╣
║    1 ║    6000 ║
║    2 ║    4000 ║
╚══════╩═════════╝

Deposits

╔══════╦══════╗
║ amt  ║   id ║
╠══════╬══════╣
║ 1000 ║    2 ║
║ 1000 ║    1 ║
║  500 ║    1 ║
║  500 ║    1 ║
╚══════╩══════╝

, , amt / . , .

create trigger d_trigger
ON Deposits
AFTER INSERT
AS
UPDATE u set u.balance=u.balance+d.amt from UList u INNER JOIN deposits d on u.id=d.id INNER JOIN inserted i on i.id=d.id

, . 500, 500 , , , 1000, . , , , ..

!

. , Java, . , MS SQL Server.

Answer 1

INNER JOIN TRIGGER . :

alter trigger d_trigger
ON Deposits
AFTER INSERT
AS
    UPDATE u 
    set u.balance=u.balance+i.amt 
    from UList u 
    INNER JOIN inserted i on i.u_Id=u.u_Id

Answer 2

, , . , .

create trigger d_trigger
ON Deposits
AFTER INSERT
AS
UPDATE UList set balance = balance + :new.amt
WHERE id = :new.id;