16-How to create/execute/test a stored procedure using Microsoft SQL Server Database

Demonstrates the following:

-Create a stored procedure (with a single parameter) from the scratch using SSMS. You can also have stored procedures with no/multiple parameters
-Execute the newly created stored procedure using SSMS (this generates code to execute a stored procedure automatically)
-Modify the generated code (to execute stored procedure) and re-execute the same (multiple number of times).