how to create a stored procedure in sql server 2008 r2 with example

for details check
http://www.technicgang.com/how-to-create-stored-procedure-in-sql-server/