text: --SQL Query that creates a sample stored procedure
  CREATE PROCEDURE getInfoFromTable
  AS
  SELECT * FROM TableName
  --Source:http://www.codingfusion.com/Post/75-Important-queries-in-SQL-Server-every-developer-should-know