update multiple columns in sql
snippet in sql

update multiple columns in sql

user8693

UPDATE table-name SET column-name = value, column-name = value WHERE condition = value

sql server update multiple columns at once

user3570

UPDATE Person.Person
 Set FirstName = 'Kenneth'
    ,LastName =  'Smith'
 WHERE BusinessEntityID = 1