Query to show all stored procedure with their code

Hi Michell,
 if you want number of line along with spname and code then use below code....
create 1 user defined function like below which return you count of line of spname you passed
and call that function in select clause..........
create FUNCTION [dbo].[CountOfLine]
( 
 -- Add the parameters for the function here
 @SPNAME varchar(max)
)
RETURNS TABLE
AS
RETURN
(
 create table #tempcnt(code varchar(max))
 
 insert into #tempcnt exec sp_helptext @SPNAME
 
 select count(*) from #tempcnt
)
and write query like below
 Select Name,OBJECT_DEFINITION(object_id) as Code,NumberOFLine= dbo.CountOfLine(Name)
 from sys.procedures

Thanks,
Pravin.

Narayan query is Correct.

For SQL Server
Select Name,OBJECT_DEFINITION(object_id) from sys.procedures