Ask a Question

DBM 294 Week 5 Individual Assignment Transactions, Errors, and Procedures

Sale price $15.00 Regular price $30.00

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.

Ask a Question