PrepAway - Latest Free Exam Questions & Answers

You need to create a stored procedure named usp_Custome…

You have a database named Sales that contains the tables shown in the exhibit.

You have an application named App1. 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 App1 that returns only the number of rows specified by the
@Count parameter. The solution must NOT use BEGIN, END, or DECLARE statements. Part of
the correct T-SQL statement has been provided in the answer area. Provide the complete code.

PrepAway - Latest Free Exam Questions & Answers

Answer: See the explanation

Explanation:
CREATE PROCEDURE usp_Customers @Count int
SELECT TOP(@Count)
Customers.LastName
FROM Customers
ORDER BY Customers.LastName


Leave a Reply