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

类别:数据库 点击:0 评论:0 推荐:

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://com.8s8s.com/it/it19803.htm