![ContractedBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
![ExpandedBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
--获取存储过程的参数,类型,长度
select a.name '参数',b.name '类型',a.length '长度'
from syscolumns a,systypes b
where id = object_id('proc_test')
and a.xtype=b.xtype
--查看存储过程的定义
exec sp_helptext 'proc_test'
转载于:https://www.cnblogs.com/laiwei85/archive/2008/12/19/1358266.html