Write a transaction to insert five rows into the Transactions table. One insert statement must have a
Fantastic news! We've Found the answer you've been seeking!
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.
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date: