在SQL Server中，您可以执行以下操作:

In SQL Server you can do something like:

UPDATE Table_1
SET Column_2 = t2.Column_2
FROM Table_1 AS t1
INNER JOIN Table_2 AS t2 ON t2.Column_1 = t1.Column_1

或类似的

UPDATE Table_1
SET Column_2 = ( 
    SELECT t2.Column_2
    FROM Table_2 AS t2
    WHERE t2.Column_1 = Table_1.Column_1
)

当然，如果Table_2中有多行，则会出现错误....

Of course if you have multiple rows in Table_2, you will get an error....