CORRECT TEXT
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, END, or DECLARE statements.
Part of the correct Transact-SQL statement has been provided in the answer area. Complete the Transact-SQL statement
A. Please review the part for this answer
CREATE PROCEDURE usp_Customers @Count INT
SELECT TOP(@Count) Customers.LastName
FROM Sales.Customers
ORDER BY Customers.lastname ;
My bad (it lacks the key word AS )
CREATE PROCEDURE usp_Customers @Count INT
AS
SELECT TOP(@Count) Customers.LastName
FROM Sales.Customers
ORDER BY Customers.Lastname ;