select case b.colid when 1 then '<存储过程名称>'+a.name else ' ' end+'
<参数 参数名称="'+b.name
+'" 参数类型="'+c.name
+case when c.name in ('binary','char','nchar','nvarchar','varbinary','varchar','float','real')
then '('+cast(b.prec as varchar)+')'
when c.name in ('decimal','numeric')
then '('+cast(b.prec as varchar)+','+cast(b.scale as varchar)+')'
else '' end+'"></参数>'
+case b.colid when (select max(colid) from syscolumns where id=a.id)
then '
</存储过程名称>' else '' end
from sysobjects a
join syscolumns b on a.id=b.id
join systypes c on b.xusertype=c.xusertype
where a.xtype='P' and a.status>=0
order by a.name,b.colid
<参数 参数名称="'+b.name
+'" 参数类型="'+c.name
+case when c.name in ('binary','char','nchar','nvarchar','varbinary','varchar','float','real')
then '('+cast(b.prec as varchar)+')'
when c.name in ('decimal','numeric')
then '('+cast(b.prec as varchar)+','+cast(b.scale as varchar)+')'
else '' end+'"></参数>'
+case b.colid when (select max(colid) from syscolumns where id=a.id)
then '
</存储过程名称>' else '' end
from sysobjects a
join syscolumns b on a.id=b.id
join systypes c on b.xusertype=c.xusertype
where a.xtype='P' and a.status>=0
order by a.name,b.colid