sql得到存储过程的参数列表

select syscolumns.*, systypes.* from syscolumns   

  left join systypes on syscolumns.xusertype=systypes.xusertype 

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