DBI202Xuất hiện trong 1 đề thi
The following SQL statement creates a stored procedure that selects Customers from a particular City with a particular PostalCode from the "Customers" table: ```sql 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?
Các lựa chọn
A```sql
EXEC SelectAllCustomers @City = 'London', @PostalCode = 'WA11DP';
```
B```sql
EXECUTE SelectAllCustomers 'London', 'WA11DP' OUTPUT
```
C```sql
EXEC @City = 'London', @PostalCode = 'WA11DP';
```
D```sql
EXECUTE SelectAllCustomers
```