Database Processing by Kroenke 14th edition
CH 10C H
Write a stored procedure to update customer phone data. Assumethat your stored procedure receives LastName, FirstName,PriorAreaCode, NewAreaCode, PriorPhoneNumber, and NewPhoneNumber.Your procedure should first ensure that there is only one customerwith the values of (LastName, FirstName, PriorAreaCode,PriorPhoneNumber). If not, produce an error message and quit.Otherwise, update the customer data with the new phone number data,and print a results message.
Expert Answer
An answer will be send to you shortly. . . . .