How to bulk update multiple rows in SQL Server at a time with different matching conditions?

Question

Aryan Kumar · Answer

Sure, here is how to bulk update multiple rows in SQL Server at a time with different matching conditions:
SQL
USE MyDatabase;
UPDATE Customers
SET
  FirstName = CASE CustomerID
    WHEN 1 THEN 'John'
    WHEN 2 THEN 'Jane'
    ELSE FirstName
  END,
  LastName = CASE CustomerID
    WHEN 1 THEN 'Doe'
    WHEN 2 THEN 'Doe'
    ELSE LastName
  END
WHERE CustomerID IN (1, 2);
This code will update the Customers table to change the first and last names of the customers with the IDs 1 and 2. The
CASE statement is used to specify different values for the FirstName and
LastName columns, depending on the value of the CustomerID column. The
WHERE clause is used to specify that the updates should only be applied to the rows where the
CustomerID column is equal to 1 or 2.
The UPDATE statement can also be used to update multiple rows with the same value for a particular column. For example, the following code would update the
CustomerID column of all rows in the Customers table to 100:
SQL
UPDATE Customers
SET CustomerID = 100;
The UPDATE statement is a powerful tool for updating data in SQL Server. It can be used to update a single row or multiple rows, and it can be used to update a single column or multiple columns.

forum

How to bulk update multiple rows in SQL Server at a time with different matching conditions?

Steilla Mitchel

Can you answer this question?

1 Answers

Liked By