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.
Use the ‘Check Syntax’ button to verify your work. Any syntax or spelling errors will be reported by line and character position.
A. Please review the explanation part for this answer
