如何得到任意一个存储过程的参数列表的???

问题描述:

有什么系统存储过程,或什么途径,可以得到任意一个存储过程的参数列表的???
:)!!!
---------------------------------------------------------------

解答:

方法1:
select c.name from syscolumns c,sysobjects o
where o.id=c.id
and o.xtype='P'
and o.name='your proc name'

方法2:
exec sp_procedure_params_rowset @procedure_name = 'storeproc name'

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus