Câu 71: 70-461: MCSA Querying Microsoft SQL Server 2012/2014

SIMULATION -You have a data warehouse that contains the data for all the customers of your company. You need to create a stored procedure that generates a list of customer addresses. The list must meet the following requirements: ✑ The procedure must accept a string value. ✑ The procedure should return all customers who reside in a city whose name begins with the provided value. ✑ If a user provides a blank value, the procedure must execute, and then return a blank result set. Part of the correct Transact-SQL has been provided in the answer area below. Enter the code in the answer area that resolves the problem and meets the stated goals or requirements. You can add code within code that has been provided as well as below it.

1. A. Please review the explanation part for this answer. 1 CREATE PROCEDURE uspGetAddress @City nvarchar(50) = ""2 AS3 SELECT *4 FROM Person.Address5 WHERE City LIKE @City *6 GOOn line 1 add "" (set the default value)On line 5 add LIKE (use string comparison) — đáp án hiện tại