For this assignment you will create the stored procedures, Functions, and Views. Capture screenshots showing the code and successful completion for each step below.

You will use the nwindsql database to do the following:

Create a stored procedure named procCategories that displays from the Categories table $($categoryName$,$ Description$)$ and Run.

Recreate your procCategories stored procedure so that the stored procedure will return all Categories or only specific Categories an input parameter for categoryName. "use the same columns.

Run the stored proc with 'Produce'

Create a stored procedure that inserts data into the shipper's table.