Which code segment should you use?

CORRECT TEXT

You have a database that contains the tables shown in the exhibit. (Click the Exhibit button.)

You have an application named Appl. You have a parameter named @Count that uses the int data type. App1 is configured to pass @Count to a stored procedure. You need to create a stored procedure named usp_Customers for Appl.

Usp_Customers must meet the following requirements:

• NOT use object delimiters.

• Minimize sorting and counting.

• Return only the last name of each customer in alphabetical order.

• Return only the number of rows specified by the @Count parameter.

• The solution must NOT use BEGIN and END statements.

Which code segment should you use? To answer, type the correct code in the answer area.

View Answer

Answer: