Question: 47
(Choose 1 answer)
The following SQL statement creates a stored procedure that selects Customers from a particular City with a
particular PostalCode from the "Customers" table:
CREATE PROCEDURE SelectAllCustomers
@City nvarchar(30),
@PostalCode nvarchar(10)
AS
BEGIN
SELECT *
FROM Customers
WHERE City @City
AND PostalCode = @PostalCode;
END;
GO
Which of the following is the way to execute a procedure?
A. EXEC SelectAllCustomers @City = 'London', @PostalCode = 'WA11DP';
B. EXECUTE SelectAllCustomers 'London', 'WA11DP' OUTPUT
C. EXEC@City = 'London', @PostalCode = 'WA11DP';
D. EXECUTE SelectAllCustomers
