得到所有用户存储过程及参数列表

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

原文转自：http://www.ltesting.net