Question: Write a script that creates and calls a stored procedure named insert_terms. First, code a statement that creates a procedure that adds a new row

Write a script that creates and calls a stored procedure named insert_terms. First, code a statement that creates a procedure that adds a new row to the TERMS table in the AP schema. To do that, this procedure should have two parameters: one for the terms_due_days column and another for the terms_description column. IF the value for the description column is NULL, the stored procedure should be able to create a default value for the description column based on the value of the due days column. For example, for a due days column of 120, the description column should have a default value of "Net due 120 days",. Then code a CALL statement that tests this procedure.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Write a script that creates and calls a stored procedure named spInsertCategory. First, code a statement that creates a procedure that adds a new row to the Categories table. To do that, this...

script that creates and calls a stored procedure named insert_category. First, code a statement that creates a procedure that adds a new row to the Categories table. To do that, this procedure should...

HW EXERCISES: PROCEDURES, FUNCTIONS, TRIGGERS In this exercise you will create scripts in the Murach College database. 1 . Write a script that creates and calls a stored procedure named...

You will use SQL and My Guitar Shop database to create SQL statements. Save your select statements as a script. Place the semicolon at the end of each SQL statement. Please number your answers from 1...

creating a sql for the guitar shop You will use SQL and My Guitar Shop database to create SQL statements. Save your select statements as a script. Place the semicolon at the end of each SQL...

Chapter 15 How to code stored procedures, functions, and triggers Exercises 1. Write a script that creates and calls a stored procedure named spInsertCategory. First, code a statement that creates a...

Exercises 1 . Write a script that creates and calls a stored procedure named insert _ category. First, code a statement that creates a procedure that adds a new row to the Categories table. To do...

1 . Write a script that creates and calls a stored procedure named spInsertDepartment. First, code a statement that creates a procedure that adds a new row to the Departments table. To do that, this...

1 . Write a script that creates and calls a stored procedure named insert _ category. First, code a statement that creates a procedure that adds a new row to the Categories table. To do that, this...

Using the My Guitar Shop database you installed in Module 1 , develop the following queries. Write a script that creates and calls a stored procedure named insert _ category. First, code a statement...

A paper recycling company converts newspaper, mixed paper, white office paper, and cardboard into pulp for newsprint, packaging paper, and print-stock quality paper. The recycler is currently trying...

Hyten Corporation On June 5, 1998, a meeting was held at Hyten Corporation, between Bill Knapp, Director of Marketing/Sales, and John Rich, director of engineering. The purpose of the meeting was to...

I need help to answer this questions but written as an article discussion providing references to support my answers, The require textbook we have been using in class is: Investments - 12th Edition...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Assume that the banking system has total reserves of $100 billion. Assume also that required reserves are 10 percent of checking deposits and that banks hold no excess reserves and households hold no...

As shown in Figure 3, the overall labor-force participation rate of men declined between 1970 and 2000. At the same time, the labor-force participation rate of women increased sharply. This overall...

The Bureau of Labor Statistics announced that in February 2008, of all adult Americans, 145,993,000 were employed, 7,381,000 were unemployed, and 79,436,000 were not in the labor force. Use this...