Q$5$: execute the stored procedure and display your invoice record. Your output should look the same as the provided solution with possible exceptions of the InvoiceID, InvoiceDate, and BookID.

Each time you execute the stored procedure, a new invoice record will be inserted with a new invoice ID$.$ In case of multiple invoice records, the grader will assess based on the last record. $(10$ points$)$

Exec Create$\_$Invoice Enter input parameters Here;

Select $*$ from invoice;

Additional information $-$

$$ Debug stored procedures

In the absence of a debugger to step through the code, we can resort to disassembling and examining code pieces. For example, ensure the insert statement functions correctly before adding the update statement.

$$ Drop or change stored procedures

To drop or modify a stored procedure, use these commands.

Drop procedure Create$\_$Invoice

Alter procedure Create$\_$Invovice $($input parameters...$)$

As

New code

$($Remember to 'execute' the altered stored procedure$)$