Get ALL Procedures Using One Query

We can get get all procedure text using a single query in SQL Server. 

Just run this query.

Select Object_Name(C.id) AS Name , text From SysComments AS C Left Join SysObjects AS O  On C.id = O.id  Where O.xtype = 'P'