This article is tagged with:
Sql server update multiple columns at once
and mysql
sql server update multiple columns at once
UPDATE Person.Person
Set FirstName = 'Kenneth'
,LastName = 'Smith'
WHERE BusinessEntityID = 1