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
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