Ms-sql Stored Procedure Manual

After we crate a procedure its must to give the manual to the front end team to make a use of it.

Creating the procedure manual is not a easy task for a bulk amount of procedures. I face this once, to make the work smarter just run the query

select o.name as procedure_name,p.name as parameter,t.name +'('+ cast(p.max_length as varchar(5))+')' as Data_type
from sys.objects o inner join sys.parameters p on o.object_id=p.object_id
inner join sys.types t on p.system_type_id=t.system_type_id
where o.type='p'