Write a script that creates and calls a stored procedure

Assignment Help Computer Engineering

Reference no: EM132213407

Question :

1. Write a script that creates and calls a stored procedure named test. This stored procedure should declare a variable and set it to the count of all products in the Products table. If the count is greater than or equal to 7, the stored procedure should display a message that says, "The number of products is greater than or equal to 7". Otherwise, it should say, "The number of products is less than 7".

2. Write a script that creates and calls a stored procedure named test. This stored procedure should use two variables to store (1) the count of all of the products in the Products table and (2) the average list price for those products. If the product count is greater than or equal to 7, the stored procedure should display a result set that displays the values of both variables. Otherwise, the procedure should display a result set that displays a message that says, "The number of products is less than 7".

3. Write a script that creates and calls a stored procedure named test. This procedure should calculate the common factors between 10 and 20. To find a common factor, you can use the modulo operator (%) to check whether a number can be evenly divided into both numbers. Then, this procedure should display a string that displays the common factors like this: Common factors of 10 and 20: 1 2 5 10

4. Write a script that creates and calls a stored procedure named test. This procedure should attempt to insert a new category named "Guitars" into the Categories table. If the insert is successful, the procedure should display this message:

Using MySQL workbench

Reference no: EM132213407

Questions Cloud

What are the main sources of the government revenues : What are the main sources of the government's revenues, including those from both governmental and business-type activities?

Calculate the amount of tuition scholarship : Liam was given a $3,000 tuition scholarship to attend Northern Law School. In addition, Northem paid Liam $4,000 per year to work part-time in the campus.

Write a search function that searches a value in an array : Write a search function that searches a value in an array, it returns 1 if the value exists, returns 0 if it does not exist.

Write a select statement that returns the same result set : Write a SELECT statement that returns the same result set as this SELECT statement, but don't use a join.

Write a script that creates and calls a stored procedure : Write a script that creates and calls a stored procedure named test. This stored procedure should use two variables to store.

Which invoices have a payment total thats greater than : Which invoices have a payment total that's greater than the average payment total for all invoices with a payment total greater than 0?

Write a server program using tcp that accepts requests : Write a server program using TCP that accepts requests from clients to capitalize strings sent by the clients.

Write a section of code that could appear in a main function : Write code to "Toss the coin" the requested number of times. You must call the function you wrote.

Find the first three positions of the string and in a string : Write a series of assignment statements (complete executable code) that find the first three positions of the string "and" in a string variable sentence.

User Account

All Pages