找出存储过程列表

select
a.name  as N'表名' ,
b.name as N'字段名',
(case when C.NAME Is null then '' else C.NAME end) AS N'数据类型',
b.prec AS N'长度',
(case when b.colstat=4 then '1'else '0' end) N'是否输出',
b.colorder N'字段序号',
d.text 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.xtype='p' and A.status>0 Order By 表名

select
a.name  as N'表名',
d.text as N'内容'
 from sysobjects a
left join syscomments d on d.id= a.id
where a.xtype='p' and a.status>0 Order By 表名

select
b.name as N'字段名',
(case when C.NAME Is null then '' else C.NAME end) AS N'数据类型',
b.prec AS N'长度',
(case when b.colstat=4 then '1'else '0' end) N'是否输出',
b.colorder 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.name='Auto_INSERT_INTO_Hr_Employee'