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: \nCREATE PROCEDURE SelectAllCustomers @City nvarchar(30), @PostalCode nvarchar(10)\nAS\nBEGIN SELECT * FROM Customers WHERE City = @City AND PostalCode = @PostalCode;\nEND;\nGO \nWhich of the following is the way to execute a procedure?
Các lựa chọn
AEXEC SelectAllCustomers @City = 'London', @PostalCode = 'WA11DP';
BEXECUTE SelectAllCustomers 'London', 'WA11DP' OUTPUT
CEXEC @City = 'London', @PostalCode = 'WA11DP';
DEXECUTE SelectAllCustomers