Exam 70-461 topic 1 question 171 discussion

Actual exam question from Microsoft's 70-461

Question #: 171
Topic #: 1

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.

Show Suggested Answer

Suggested Answer: Please review the explanation part for this answer.
1 CREATE PROCEDURE uspGetAddress @City nvarchar(50) = ""
2 AS
3 SELECT *
4 FROM Person.Address
5 WHERE City LIKE @City *
6 GO
On line 1 add "" (set the default value)
On line 5 add LIKE (use string comparison)

by Nickforguest at Jan. 18, 2021, 8:55 p.m.

Comments

Submit Cancel

Nickforguest

4 years, 5 months ago

This query doesn't return a blank rrsult set od a User provide blank value

upvoted 1 times

...