Create a procedure that accepts a customer id and retrieves the id of the products and quantities
Question:
Create a procedure that accepts a customer id and retrieves the id of the products and quantities that the customer ordered. Use an anonymous to call the procedure and output the result.
Create a procedure to insert a row into the product table with appropriate values. Use an anonymous to call the procedure and output the result.
Create a procedure that accepts a category name and retrieves the product and the total sales for the category. Use an anonymous to call the procedure and output the result.
Create a stored procedure to retrieve the n most expensive products, where n is a number. Use an anonymous block to call the stored procedure and display the results. Use an anonymous to call the procedure and output the result.
Using Microsoft Excel and Access 2016 for Accounting
ISBN: 978-1337109048
5th edition
Authors: Glenn Owen