subject

Write a script that creates and calls a stored procedure named test. this procedure should include two sql statements coded as a transaction to delete the row with a customer id of 8 from the customers table. to do this, you must first delete all addresses for that order from the addresses table.

if these statements execute successfully, commit the changes. otherwise, roll back the changes.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 02:00
Aisha has finished working on a word processing document that contains 15 pages. she has added some special elements in the first three pages, page 9 and 10, and page 15 from the document. she wants to print only these pages to see how they look. which option is the correct way to represent (in the print dialog box) the pages that aisha wants to print?
Answers: 1
question
Computers and Technology, 22.06.2019 04:00
Which of the following kinds of programs displays an online advertisement in a banner or pop-up window on webpages, email, or other internet service? e
Answers: 2
question
Computers and Technology, 22.06.2019 10:00
You need a reliable network for about twenty-five computers that will be distributed across a large building. it is important that the network be relatively cheap. which topology should you use?
Answers: 1
question
Computers and Technology, 22.06.2019 22:30
Who needs to approve a change before it is initiated? (select two.) -change board -client or end user -ceo -personnel manager -project manager
Answers: 1
You know the right answer?
Write a script that creates and calls a stored procedure named test. this procedure should include t...
Questions
question
English, 10.06.2021 02:40
question
Mathematics, 10.06.2021 02:40
question
Mathematics, 10.06.2021 02:40
Questions on the website: 13722360