DBM 294 Week 5 Individual Assignment Transactions, Errors, and Procedures
Extend the SQL script you developed for the Week Four individual
Write additional SQL commands in your script that demonstrate use of
the following techniques. These commands should interact with the
tables you have been creating.
Include the following:
- A stored procedure that accepts at least one parameter and updates
one or more records based on the value passed in the parameter.
- Two update commands made as part of the same transaction.
- An error handler that executes if there is an error with a transaction.
Using the Assignment Files tab:
Submit your SQL script.
Submit a document containing screen shots of each SQL command
and the corresponding output.
Questions & Answers
Have a Question?
Be the first to ask a question about this.