取得存儲過程參數個數

Select sysColumns.name ColName,
       sysTypes.name ParamName,
       SysColumns.length,
       SysColumns.xprec,
       SysColumns.xscale,
       SysColumns.isOutparam
  from SysObjects
       Join sysColumns
            On SysObjects.id = SysColumns.id
       Join sysTypes
            On SysTypes.xtype = SysColumns.xtype
 where SysObjects.Name = 'RGM010P01'
   And SysObjects.xtype = 'P'
 Order by SysColumns.colorder