Question: Create a stored procedure that inserts a new customer and new address. Accept necessary values as arguments. Be sure to use proper error handling and

Create a stored procedure that inserts a new customer and new address. Accept necessary values as arguments. Be sure to use proper error handling and transaction processing in your stored procedure. Paste the procedure below and use the following values to test your stored procedure. (You can make up or look up needed values other than those below for the new records.) Copy the result from each test.
a. Customer_(i)d: 999; Name: Frank Johnson; Email: FrankyJ@norman.com; Address: 123 Rue St. Norman OK 73019
b. Customer_(i)d: 599; Name: Maggie Smith; Email: Mag@norman.com; Address: 123 Ulitsa St. Norman OK 73019
c. Assume country = USA

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

Please use the Sakila database on MySQL for the following problems. Create a stored procedure that inserts a new customer and new address. Accept necessary values as arguments. Be sure to use proper...

Q:

Assignment 4 : Advanced MS SQL Stored Procedures Individual Assignment | 7 . 5 % Objective: To design and implement stored procedures with error handling and transactions for a retail store...

Q:

Use Northwind /* 1. Create a stored procedure that produces a list of all Suppliers in a specified Region. The procedure should accept 1 input parameter: Region. The supplier list produced by the...

Q:

The language is: T-SQL The goal is to create a stored procedure that uses TRY/CATCH and error handling functions. The stored procedure must be named MyOrdersInsert, it will insert into the...

Q:

Question: The goal is to create a stored procedure that uses TRY/CATCH and error handling functions. The stored procedure, MyOrdersInsert, will insert into the dbo.MyOrders table. Use the following...

Q:

Create a stored procedure that uses a cursor to iterate through all of the films in the film table and update the rental _ duration values. For durations

Q:

I have attached both the chapters from which you will be answering the following question. Ch 8 (p 387 of text or p 35 of the pdf) ?Exercise D. Prepare the bank reconciliation and any required...

Q:

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Q:

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

Q:

Overview of the case. What do you think of the particular assignment given to Browning? TEXTBOOK : Brown, C.V., DeHayes, D.W., Hoffer, J.A., Martin, E.W., and Perkins, W.C. Managing Information...

Q:

Margaret is reading a book. The number of pages she has left to read it 356-42d, where d represents the number of days she has been reading. What does each part of the expression represent?

Q:

Determine the magnitude and coordinate direction angles of the resultant force acting at pointA. 1.5m F, = 1 50 N F2 = 200 N -2 m-

Q:

ABC LLC is a partnership that develops and implements computer software to its customers internationally. ABC incurred $ 2 0 0 , 0 0 0 of expenses for the research and development costs in 2 0 2 4 ....

Q:

Which one of the following best illustrates erosion as it relates to a hot dog stand located on the beach? selling fewer hot dogs because hamburgers were added to the menu repairing the roof of the ho