Which five Transact-SQL segments should you use to develop the solution?

DRAG DROP

You need to create a stored procedure to update a table named Sales.Customers.

The structure of the table is shown in the exhibit. (Click the exhibit button.)

The stored procedure must meet the following requirements:

– Accept two input parameters.

– Update the company name if the customer exists.

– Return a custom error message if the customer does not exist.

Which five Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.

NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

View Answer

Answer: