Computers and Technology

Computers and Technology, 15.11.2019 02:31, ilovecatsomuchlolol

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.

answer

Answers: 2

Show answers

Similar questions

Предмет

Computers and Technology, 06.08.2019 17:10, kam110800

Write a script that creates and calls a stored procedure named test. this procedure should include these statements coded as a transaction: insert into orders values(default, 3, '10.00', '0.00', null, 4,'american express', '378282246310005', '04/2013', 4); select last_insert_id()into order_id; insert into order_items values(default, order_id, 6, '415.00', '161.85', 1); insert into order_items values(default, order_id, 1, '699.00', '209.70', 1); here, the last_insert_id function is used to get the order id value that

Answers: 3

Предмет

Engineering, 08.11.2019 19:31, joshsd8479

Use northwind database and base your stored procedure off the columns found in the customer table. write a stored procedure named, custregion, that accepts a region as a parameter. the stored proc is to return only the customerid, companyname, and the region. write it so that it can return those rows where the region is a null value as well as allowing the user to submit via the parameter a region name such as bc, sp, or, df, isle of wight, etc. note: you must test for a null value using the is null statement and can't code a where clause using an '= null' as that is not correct and will result in no rows being returned.

Answers: 1

Предмет

Computers and Technology, 10.11.2019 14:31, tra80

Write a script that creates and calls a stored procedure named test. this procedure should include these statements coded as a transaction: insert into orders values (default, 3, '10.00', '0.00', null, 4, 'american express', '378282246310005', '04/2013', 4); select last_insert_id() into order_id; insert into order_items values (default, order_id, 6, '415.00', '161.85', 1); insert into order_items values (default, order_id, 1, '699.00', '209.70', 1); here, the last_insert_id function is used to get the order id value that

Answers: 2

Предмет

Computers and Technology, 20.11.2019 16:31, Derienw6586

Write a script that creates and calls a stored procedure named insert_category. first, code a statement that creates a procedure that adds a new row to the categories table. to do that, this procedure should have one parameter for the category name. code at least two call statements that test this procedure. (note that this table doesn�t allow duplicate category names.)

Answers: 2

Do you know the correct answer?

Write a script that creates and calls a stored procedure named test. this procedure should include t...

Questions in other subjects:

Konu

History, 04.08.2019 17:00

What is the first attempt at an english colony in the new world?...

Konu

Mathematics, 04.08.2019 17:00

Evaluate 8a+3b-10+c^28a+3b−10+c 2 8, a, plus, 3, b, minus, 10, plus, c, start superscript, 2, end superscript when a=2a=2a, equals, 2, b=5b=5b, equals, 5, and c=4c=4c, equals, 4....

Konu

Social Studies, 04.08.2019 17:00

Let k = 7. drag the expression into the box that makes the comparison true. 50−k2=...

Konu

Mathematics, 04.08.2019 17:10

30% chance you will be elected president of the history club and 20 percent chance your friend will be elected treasurer what is the experimental probability...

Konu

Mathematics, 04.08.2019 17:10

Having trouble with questions 1, 3, 4 exercise 9.05 modelling exponential functions 1 a full 30 000 l cylindrical rainwater tank has sprung a leak in the seam at...

Konu

English, 04.08.2019 17:10

What is journalism based on todays world?...

Konu

Mathematics, 04.08.2019 17:10

Hi, j have some questions i don’t understand can you me with

Konu

Chemistry, 04.08.2019 17:10

Why nitro group is called an ambident group?...

Konu

Geography, 04.08.2019 17:10

Mention the geographical requirements for the growth of wheat in india. list out any two wheat growing zones in india....

Konu

Mathematics, 04.08.2019 17:10

Need to find derivative of y=4x^3+8^1/3/(x+2)^5...

Other tasks in the category: Computers and Technology More task