Question: Exercise 16-2 [20 points] Write a script that includes these statements coded as a transaction: INSERT Orders VALUES (3, GETDATE(), '10.00', '0.00', NULL, 4, 'American

Exercise 16-2 [20 points] Write a script that includes these statements coded as a transaction:

INSERT Orders VALUES (3, GETDATE(), '10.00', '0.00', NULL, 4, 'American Express', '378282246310005', '04/2019', 4);

SET @OrderID = @@IDENTITY;

INSERT OrderItems VALUES (@OrderID, 6, '415.00', '161.85', 1);

INSERT OrderItems VALUES (@OrderID, 1, '699.00', '209.70', 1);

Here, the @@IDENTITY variable is used to get the order ID value thats automatically generated when the first INSERT statement inserts an order.

If these statements execute successfully, commit the changes. Otherwise, roll back the changes.

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 Databases Questions!

Q:

2. Write a script that includes these statements coded as a transaction: INSERT Orders VALUES (3, GETDATE(), '10.00', '0.00', NULL, 4, 'American Express', '378282246310005', '04/2013', 4); SET...

Q:

1. Write a script that includes two SQL statements coded as a transaction to delete the row with a customer ID (CustomerID) of 8 from the Customers table. To do this, you must first delete all...

Q:

1. Write a script that includes these statements coded as a transaction: INSERT Orders VALUES (3, GETDATE(), '10.00', '0.00', NULL, 4, 'American Express', '378282246310005', '04/2013', 4); SET...

Q:

Write a script that includes these statements coded as a transaction: INSERT Orders VALUES (3, GETDATE(), '10.00', '0.00', NULL, 4, 'American Express', '378282246310005', '04/2013', 4); SET @OrderID...

Q:

1. 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...

Q:

2. 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, NOW(), '10.00',...

Q:

7. 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, NOW(), '10.00',...

Q:

Tables_bookstore_database: USE bookstore; /* drop the tables */ DROP TABLE IF EXISTS orderitems; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS customer; DROP TABLE...

Q:

Tables_bookstore_database: USE bookstore; /* drop the tables */ DROP TABLE IF EXISTS orderitems; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS customer; DROP TABLE...

Q:

Tables_bookstore_database: USE bookstore; /* drop the tables */ DROP TABLE IF EXISTS orderitems; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS customer; DROP TABLE...

Q:

Identify five examples of forensic accounting engagements that commonly require the analysis of financial statements and discuss how mindset might impact this type of analysis.

Q:

Referring to Exercise 8.44, determine the sample size needed in order to be 99 percent confident that p, the sample proportion of ColorSmart-5000 television sets that last at least five years without...

Q:

A company superintendent uses his own funds to pay for changing the will negative. A company vehicle The superintendent will provide the money in their paycheck. At the next payroll, would you credit...

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

LO1 Identify the three general components of total rewards and give examples of each.

Q:

2. If you were to implement stack ranking in a company, how would you do it? What are the potential challenges associated with implementing this system? Would you use it, or would you elect to use an...

Q:

LO5 Illustrate the steps in developing a base pay system.