Update Multiple Columns in SQL Server Here we want to update EmployeeNumber in Table1 from EmployeeNumber in Table2 where the id is 108912.