作者:schell | 来源:互联网 | 2023-08-23 09:18
WherecanIfindinformationaboutstoredprocedureparameters?InmysituationIneedtoknowonly
Where can I find information about stored procedure parameters? In my situation I need to know only the input parameters of given store procedure.
在哪里可以找到有关存储过程参数的信息?在我的情况下,我只需要知道给定存储过程的输入参数。
In the sys.objects
there is only common details about the procedure. In sys.sql_modules
I can extract the whole SQL text of a procedure.
在系统。对象关于过程只有一般的细节。在系统。我可以提取一个过程的整个SQL文本。
As (in SQL Server Management studio) I am able to extract information about the parameters in tabular view using ALT+F1
when selecting the procedure name, I hope there is some place from which I get extract them in that way.
As(在SQL Server Management studio中)在选择过程名时,我可以使用ALT+F1提取表视图中参数的信息,我希望有某个地方可以这样提取它们。
5 个解决方案