请问如何获取存储过程的参数？？

[jacksg]

获取存储过程的的办法是
select name from sysobjects where xtype='P'
但是我还想获取相应存储过程的参数，请教如何做？谢谢～～

[hsj20041004]

exec sp_helptext "存储过程名"

[jacksg]

解决不了实际问题～～

[ilons1]

select * from syscolumns where id in(select id from sysobjects where name = 'Spname')

[winternet]

/* 读取 SQLServer 的 所有用户定义的 存储过程 和 参数 名称 */

If exists (select * from sysobjects where xtype='FN' and name='fmerg')
drop function fmerg
go
create Function fmerg(@ProcedureName nvarchar(90))
returns nvarchar(4000)
as
begin
declare @s nvarchar(4000)
select @s=''
select @s=@s+','+Parameter
From (select b.Name as ProcedureName,a.Name as Parameter
from syscolumns as a inner join sysobjects as b on a.ID=b.ID and b.xtype='P' and b.Name not like 'dt_%')d
where ProcedureName=@ProcedureName
select @s=stuff(@s,1,1,'')

return(@s)
end
go
select distinct ProcedureName,dbo.fmerg(ProcedureName)
from (select b.Name as ProcedureName,a.Name as Parameter
from syscolumns as a inner join sysobjects as b on a.ID=b.ID and b.xtype='P' and b.Name not like 'dt_%')d

drop function fmerg

[iwl]

select * from syscolumns where id in(select id from sysobjects where name = 'Spname')

[zhangyang555]

select name from syscolumns where id in(select id from sysobjects where name = '存储过程名称')