Write a transaction to insert five rows into the Transactions table. One insert statement must have a NULL value in

Write a transaction to insert five rows into the Transactions table. One insert statement must have a NULL value in

Question:

Write a transaction to insert five rows into the Transactions table. One insert statement must have a NULL value in TheData and one must be a duplicate of a value previously inserted into TheID. If all inserts are successful Commit the transaction. If not, Rollback the transaction and display the ERROR_NUMBER and ERROR_MESSAGE. Execute the transaction block. Take a screen shot of the SQL windows and results and paste it here.

Expert Answer:

Answer rating: 100% (QA)

Solution I have written a transaction to insert five rows into the Transactions table as per your
View the full answer