By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE [user] (id INT PRIMARY KEY, [update] INT);
INSERT INTO [user] VALUES (1,0), (2,0), (3,0), (4,0);
CREATE TABLE routes (user_id INT, route INT, FOREIGN KEY (user_id) REFERENCES [user] (id));
4 rows affected
CREATE TRIGGER tr
ON routes
AFTER INSERT
AS
UPDATE [user]
SET [update] = 1
FROM INSERTED
WHERE id = INSERTED.user_id;
SELECT * FROM [user];
INSERT INTO routes VALUES (1,1), (2,2), (1,3);
SELECT * FROM [user];
| id | update |
|---|---|
| 1 | 0 |
| 2 | 0 |
| 3 | 0 |
| 4 | 0 |
| id | update |
|---|---|
| 1 | 1 |
| 2 | 1 |
| 3 | 0 |
| 4 | 0 |