You need to create a stored procedure named usp_Custome…

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

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

Answer: See the explanation

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

Show Hint

← Previous question

Next question →