select a.name as procedure_name,b.name as parameter_name,b.is_output, c.name as parameter_datatype,b.max_length as parameter_length from sys.objects a join sys.all_parameters b on a.object_id=b.object_id join sys.types c on b.system_type_id=c.system_type_id where a.type='P' order by a.name
c.name as parameter_datatype,b.max_length as parameter_length
from sys.objects a join sys.all_parameters b
on a.object_id=b.object_id
join sys.types c on b.system_type_id=c.system_type_id
where a.type='P'
order by a.name