You have a database that contains the tables shown in the exhibit. (Refer to the Exhibit.)
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 thefollowing 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.
A.
Explanation:
CREATE PROCEDURE usp_Customers @Count int
AS
SELECT TOP(@Count) Customers.LastName
FROM Customers
ORDER BY Customers.LastName
The recommendation is to use (SQL) standard if equivalent standard is available:
CREATE PROCEDURE usp_Customers @Count int
AS
SELECT Customers.LastName
FROM Customers
ORDER BY Customers.LastName
OFFSET 0 ROWS FETCH NEXT @Count ROWS ONLY
0
0
CREATE PROCEDURE usp_Customers @Count int
AS
SELECT TOP(@Count) Customers.LastName
FROM Customers
ORDER BY Customers.LastName
0
0
why top?
1
0
CREATE PROCEDURE usp_Customers
@Count INT
AS
SELECT COUNT(@Count) ,Customers.LastName
FROM Customers
ORDER BY Customers.LastName
0
0