动态获取存储过程的参数
sql server2005执行这条存储过程,你可以动态的获取你想要的存储过程参数:
1
select
2
specific_catalog as DataName, --库名
3
parameter_name as ParamName, --参数
4
data_type as DataType, --类型
5
ordinal_position as Position --位置
6
from INFORMATION_SCHEMA.PARAMETERS where specific_name='存储过程名'
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
5
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
6
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
一个人能够走多远,取决于与谁同行