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

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

ALTERPROCEDUREGetDataBaseInfo9

AS
select(casewhenb.colorder=1orb.colorderIsnullthena.nameelse''end) asN'表名',b.nameasN'字段名',C.NAMEASN'数据类型',b.precASN'长度',(casewhenb.colstat=4then'√'else''end)N'是否输出',b.colorderN'字段序号',(casewhenb.colorder=1orb.colorderIsnullthend.textelse''end) asN'内容'fromsysobjectsaleftjoinsyscolumnsbonb.id=a.idleftjoinsystypesCon(C.xtype=B.xtypeandc.name<>'sysname')leftjoinsyscommentsdond.id=a.idwherea.schema_ver=0anda.xtype='p'orderbya.name,b.colorder 
 RETURN
--ByHuntFox
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>