Your Microsoft SQL Server application database includes a table named Orders. This table includes a primary key column named OrderID and a column named Status. You must write a statement to set the Status column to the value of a parameter named @status for the row with the OrderID column matching the value of a parameter named @orderID.

Which statement should you use?

The UPDATE statement can change data values in single rows, groups of rows, or all the rows in a table or view. The SET clause contains a comma-separated list of the columns to be updated and the new value for each column in the form column_name = expression. The FROM clause identifies the tables or views that supply the values for the expressions in the SET clause. The WHERE clause specifies the search condition that defines the rows from the source tables and views that qualify to provide values to the expressions in the SET clause

The columns to modify must be given in the SET clause, not the WHERE clause.

A SELECT query does not update a table.