select c.name from syscolumns c,sysobjects o
where o.id=c.id
and o.type='p'
and o.name='your proc name'如果还需要类型,可以再连接systypes.
where o.id=c.id
and o.type='p'
and o.name='your proc name'如果还需要类型,可以再连接systypes.
exec sp_procedure_params_rowset @procedure_name = 'storeproc name'
配合使用,:)