SQL Server – How to copy data value in column from one table to another

update a
 set a.some_column = b.some_column
 from some_database.dbo.some_table a
 JOIN some_database.dbo.some_table b ON 
      a.some_column = b.some_column
 where a.some_column = 'some_value'
Please follow and like us: