得到所有用户存储过程及参数列表-数据库专栏,SQL Server

alter procedure getdatabaseinfo9

as
select (case when b.colorder=1 or b.colorder is null then a.name else end)  as n表名 ,b.name as n字段名 ,c.name as n数据类型 ,b.prec as n长度,(case when b.colstat=4 then √else end) n是否输出, b.colorder n字段序号,(case when b.colorder=1 or b.colorder is null then d.text else end)  as n内容 from sysobjects a left join syscolumns b on b.id=a.id left join systypes c on (c.xtype=b.xtype and c.name<>sysname) left join syscomments d on d.id= a.id where a.schema_ver=0 and a.xtype=p order by a.name,b.colorder 
 return
— by huntfox