Create new stored procedure in sql server 2008

Create new stored procedure in sql server 2008

Create new table and stored procedure in sql server 2008.