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


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

 

Instructions:

Extend the SQL script you developed for the Week Four individual

assignment.

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