sql2000查询存储过成的参数

select syscolumns.name, systypes.name, syscolumns.length from syscolumns   
left join systypes on syscolumns.xusertype=systypes.xusertype  
where id=(select id from sysobjects where name=存储过程名')

exec [





数据库名]..sp_procedure_params_rowset N'存储过程名',1,NULL,NULL