python - 获取 SQL Server 存储过程输入参数的方法
问题描述
有什么方法可以使用 python 来获取 SQL Server 存储过程的输入参数名称和参数个数?
该应用程序是一个 python GUI,允许用户选择他们想要调用的存储过程。When a particular stored procedure is selected, associate GUI view will change according to what input parameter this stored procedure has.
解决方案
查询自sys.parameters
select *
from sys.parameters
where object_id = object_id ('stored procedure name')
推荐阅读
- go - How do I import annotations into proto?
- visual-studio-code - How can I solve this yeoman generator code error
- python - 使用python从oracle数据库中的多个表中获取数据并将这些数据插入到另一个表中
- c# - 仅当存在时如何检查linq中数组的第二个元素
- php - How to proxy Headless Wordpress WPGraphQL Plugin Endpoint with NGINX?
- json - Flutter - Pass variable to another screen for URL GET JSON
- bash - How can we rearrange a table with bash?
- python - pandas: how to set the wrap in a dataframe
- c# - How to use increment and decrement operators for 'this' keyword?
- json - Not able to read values through Graph API JSON response