Assume a scenario where you have a temporary table contains the data and would like to update a table using the values from the temporary table.
Here’s an query demonstrating how to do it in SQL Server.
UPDATE Employee SET Employee.Name = TempEmployee.Name, Employee.Address = TempEmployee.Address FROM Employee INNER JOIN TestEmployee AS TempEmployee ON Employee.id = TempEmployee.id WHERE Employee.company = 'abundantcode'
Leave a Reply