question

--There are 3 tables: TableA, TableB and TableC. CREATE TABLE TableA (Id INT, Value VARCHAR(50)); CREATE TABLE TableB (Id INT, Value VARCHAR(50)); CREATE TABLE TableC (Id INT, Value VARCHAR(50)); --All tables are having triggers: TableA with trigger TriggerTableA, TableB with trigger TriggerTableB, and TableC with trigger TriggerTableC. CASE 1: UPDATE TABLE TableA SET Value='Updateing' WHERE Id=2 CREATE TRIGGER TriggerTableA ON TableA AFTER UPDATE AS UPDATE TableA SET Value='Updated TableA' WHERE Id= Inserted.Id CASE 2: UPDATE TABLE TableA SET Value='Updateing' WHERE Id=2 CREATE TRIGGER TriggerTableA ON TableA AFTER UPDATE AS UPDATE TableB SET Value='Updated TableB' WHERE Id= Inserted.Id CREATE TRIGGER TriggerTableB ON TableB AFTER UPDATE AS UPDATE TableB SET Value='Updated' WHERE Id= Inserted.Id CASE 3: UPDATE TABLE TableA SET Value='Updateing' WHERE Id=2 CREATE TRIGGER TriggerTableA ON TableA AFTER UPDATE AS UPDATE TableB SET Value='Updated TableB' WHERE Id= Inserted.Id CREATE TRIGGER TriggerTableB ON TableB AFTER UPDATE AS UPDATE TableC SET Value='Updated TableC' WHERE Id= Inserted.Id CREATE TRIGGER TriggerTableC ON TableC AFTER UPDATE AS UPDATE TableC SET Value='Updated' WHERE Id= Inserted.Id --I know the output of all the cases, but don't know how it is happening. Please explain it.