select '参数名称' = name,
'参数类型' = type_name(xusertype),
'参数长度' = length,
'参数顺序' = colid,
'是否输出参数'=isoutparam
from syscolumns
where id=object_id('存储过程名称')
转载于:https://www.cnblogs.com/leep2007/archive/2012/12/12/2814791.html