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.
Select and Place:
Answer: 
I approve
17
0
I think the 2nd and 3rd segments can exchange the position with 4th and 5th ones.
2
4
Not the kind of answer we are used to.
0
0
Instead THROW should be ;THROW – better standard.
0
0