저장 프로시저 목록 뽑기..

저장 프로시저 목록 뽑기..

select
  '프로시저명' = o.name
, '파라미터명' = p.name
, 'Type' = type_name(user_type_id) + (
               case when (type_name(user_type_id) = 'varchar' or type_name(user_type_id) = 'nvarchar' or type_name(user_type_id) ='char' or type_name(user_type_id) ='nchar')
                  then '(' + cast(max_length as varchar) + ')'
                when type_name(user_type_id) = 'decimal' 
                     then '(' + cast([precision] as varchar) + ',' + cast(scale as varchar)   + ')'
               else ''
               end           
               )
from sys.sysobjects o left outer join sys.parameters p
  on o.id = p.object_id
where xtype in ('x','p') order by o.name, p.parameter_id