How do I auto update table data based on another table value?

<pre>
--I hope this help full instead of Triggers offcourse Triggers is performance issue.
--I Have created sample table 
Declare @tableA table(Id int identity(1,1),Name Varchar(400));
Declare @Temp   table(Id INT,Name Varchar(400));
Declare @table1 table(Id int identity(1,1),Name Varchar(400));

---inserted same records in both tables @tableA and @table1

INSERT INTO @tableA VALUES('harish'),('santosh'),('sai'),('satish');

INSERT INTO @table1 VALUES('harish'),('santosh'),('sai'),('satish');

SELECT * FROM @tableA  WHERE id=2;
--updates name with 'NigamLucky' instead of 'santosh' in table @tableA
UPDATE @tableA SET Name='NigamLucky' OUTPUT INSERTED.* INTO @Temp  WHERE id=2;
--updates new values are inserted in @temp 
if(@@ROWCOUNT<>0)
BEGIN --@temp is joined and updated with @table1
UPDATE t1 set t1.name=t.Name from @table1 AS t1 INNER JOIN @Temp  AS t ON(t1.id=t.id)
END;
SELECT * FROM @tableA  WHERE id=2;
SELECT * FROM @table1  WHERE id=2;