Hi SUJAYS,
Refer below query.
SQL
DECLARE @Test1 AS TABLE(ID INT IDENTITY, Col1 VARCHAR(10))
DECLARE @TEMP AS TABLE(ID INT, [columns] VARCHAR(10))
INSERT INTO @Test1 VALUES('A')
INSERT INTO @Test1 VALUES('B')
INSERT INTO @Test1 VALUES('C')
INSERT INTO @Test1 VALUES('D')
DECLARE @Test2 AS TABLE(ID INT IDENTITY, Col2 VARCHAR(10))
INSERT INTO @Test2 VALUES('I')
INSERT INTO @Test2 VALUES('J')
INSERT INTO @Test2 VALUES('K')
INSERT INTO @Test2 VALUES('L')
INSERT INTO @TEMP(ID,[columns])
SELECT * FROM @Test1
UPDATE @Test1 SET t1.col1 = t2.col2
FROM @Test1 t1 INNER JOIN @Test2 t2 ON t1.ID = t2.ID
UPDATE @Test2 SET t1.col2 = t2.[columns]
FROM @Test2 t1 INNER JOIN @TEMP t2 ON t1.ID = t2.ID
SELECT * FROM @Test1
SELECT * FROM @Test2
Output
