CREATE, ALTER, EXECUTE and DROP a stored Procedure in MS SQL

This video explains how to Create, Alter, Execute a Stored Procedure in MS SQL. First I create a simple stored procedure to return all rows from a table. Then I modify the Stored Procedure to return value based on a given parameter. Then I Drop the Procedure. I have tried to keep this video simple.

Prerequisites:

1. SQL knowledge
2. A little idea about Stored Procedures.