Use below query to find out parameters for Stored Procedure
SELECT Schema_Name(Schema_ID) AS Schema_Name,
O.Type_Desc,
O.Name AS Object_Name,
P.Parameter_ID,
P.Name AS Parameter_Name,
Type_Name(P.User_Type_ID) AS Parameter_Type,
P.MAX_Length,
P.Precision,
P.Scale,
P.IS_Output
FROM SYS.Parameters AS P INNER JOIN SYS.Objects AS O
ON O.Object_ID = P.Object_ID
WHERE O.Object_ID = Object_ID('<Stored Procedure>')
ORDER BY Schema_Name, P.Parameter_ID;
Replace <Stored Procedure> with Original Stored Procedure name.
SELECT Schema_Name(Schema_ID) AS Schema_Name,
O.Type_Desc,
O.Name AS Object_Name,
P.Parameter_ID,
P.Name AS Parameter_Name,
Type_Name(P.User_Type_ID) AS Parameter_Type,
P.MAX_Length,
P.Precision,
P.Scale,
P.IS_Output
FROM SYS.Parameters AS P INNER JOIN SYS.Objects AS O
ON O.Object_ID = P.Object_ID
WHERE O.Object_ID = Object_ID('<Stored Procedure>')
ORDER BY Schema_Name, P.Parameter_ID;
Replace <Stored Procedure> with Original Stored Procedure name.
No comments:
Post a Comment