Question: 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',

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 @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:

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',...

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:

Excercises 1 . Write a script that includes two SQL statements coded as a transaction to delete the row with a student ID of 1 0 from the Students table. To do this, you must first delete all courses...

Q:

SQL Assignment. TIA SQL Table How to code subqueries Exercises 1. Write a SELECT statement that returns the same result set as this SELECT statement, but don't use a join. Instead, use a subquery in...

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:

For the following objective function and constraints: aximize P 5 + 7x + 4y 0 y 2 0 Write the initial Simplex tableau: The first pivot column is Select an answer...

Q:

Lauprechta Inc. Company has the following employees on payroll: Semimonthly Payroll Withholding Allowances Marital Status Naila $ 5,800 4 Married Wilfred $ 5,000 3 Married Byron $ 3,200 1 Single...

Q:

You can elect to receive Social Security retirement benefits Question 1 5 options: and limit your ability to keep on working and earning income. at the full retirement age, which is being raised from...

Q:

Elija la respuesta que describa correctamente cmo un contribuyente de pequea empresa que califica puede deducir el costo de su inventario

Q:

KEY QUESTION Suppose that a price-discriminating monopolist has segregated its market into two groups of buyers, the first group described by the demand and revenue data that you developed for...

Q:

The demand and revenue data for the second group of buyers is shown in the accompanying table. Assume that MC is $13 in both markets and MC ATC at all output levels. What price will the firm charge...

Q:

KEY QUESTION Compare the elasticity of the monopolistic competitors demand with that of a pure competitor and a pure monopolist. Assuming identical long-run costs, compare graphically the prices and...