SELECT column_name(s) FROM table_name WHERE column_name IN (value1, value2, ...);
UPDATE Person.Person Set FirstName = 'Kenneth' ,LastName = 'Smith' WHERE BusinessEntityID = 1