How to set a trigger to change the value in a field when a change is made in another field?

Question

SQL

How to set a trigger in Microsoft SQL Server
There are two tables

Table 1 users
id
update

Table 2 routes
user_id (connection to the users table id field)
route

By default, the update field is 0.
If there are any changes in the route, the field update is set to 1
in case it happens

Answer 1

CREATE TRIGGER tr
ON routes
AFTER INSERT 
AS 
UPDATE [user]
SET [update] = 1
FROM INSERTED
WHERE id = INSERTED.user_id;

fiddle