프로스저 명세서 출력(퍼옴)

SELECT   SO.NAME AS ProcedureName,
         PM.NAME AS ParameterName,
         CASE TYPE_NAME(PM.USER_TYPE_ID)
             WHEN 'VARCHAR' THEN 'VARCHAR('+ CAST(PM.MAX_LENGTH
                   AS VARCHAR(10)) +')'
             WHEN 'CHAR'    THEN 'CHAR('+ CAST(PM.MAX_LENGTH
                   AS VARCHAR(10)) +')'
             ELSE TYPE_NAME(PM.USER_TYPE_ID)
         END AS DataType,
         CASE PM.IS_OUTPUT
             WHEN 1 THEN 'OUTPUT'
             ELSE 'IN'
         END AS IOType
FROM     SYS.OBJECTS AS SO, SYS.PARAMETERS AS PM
WHERE    SO.OBJECT_ID = PM.OBJECT_ID
AND      SO.OBJECT_ID IN
(
    SELECT  OBJECT_ID
    FROM    SYS.OBJECTS
    WHERE   TYPE IN ('P') -- FN, P
)
AND      PM.PARAMETER_ID <> 0
ORDER BY SO.NAME, PM.PARAMETER_ID

 

 

--- from :  http://tiger5net.egloos.com/5448929

 

감사감사