UPDATE table-name SET column-name = value, column-name = value WHERE condition = value
UPDATE Person.Person Set FirstName = 'Kenneth' ,LastName = 'Smith' WHERE BusinessEntityID = 1