We can update more than one column for more than one rows in a single update query code example
Example: sql server update multiple columns at once
UPDATE Person.Person
Set FirstName = 'Kenneth'
,LastName = 'Smith'
WHERE BusinessEntityID = 1