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.
Answer: See the explanation.
Explanation:
CREATE PROCEDURE usp_Customers @Count int
AS
SELECT TOP(@Count) Customers.LastName
FROM Customers
ORDER BY Customers.LastName
CREATE PROCEDURE usp_Customers (@Count int)
as
SELECT top @Count LastName FROM Customers
WHERE
ORDER BY CustomerId, LastName ASC
RETURN
;