write a stored procedure to print information of an invoice. The procedure should take one input argument: invoice number. After searching the database for the invoice, your program will print the following information:

• Invoice number, invoice date
• Total number of products
• Total purchase amount
• Total amount after discount (if the total purchase amount is >=$200, apply a 10% off discount)

Answer rating: 100% (QA)

CREATE PROCEDURE printinvoiceinfo IN invoicenumber INT BEGIN Declare vari... View the full answer