I want to extract meta data for stored procedure from dbc tables something like this.
select
a.name AS [ParameterName],
a.parameter_id AS [ParameterID],
TYPE_NAME(a.user_type_id) AS [ParameterDataType],
a.max_length AS [ParameterMaxBytes],
a.is_output AS [IsOutPutParameter]
from
sys.parameters a
;
I want to extract meta data for stored procedure from dbc tables something like this.
select
a.name AS [ParameterName],
a.parameter_id AS [ParameterID],
TYPE_NAME(a.user_type_id) AS [ParameterDataType],
a.max_length AS [ParameterMaxBytes],
a.is_output AS [IsOutPutParameter]
from
sys.parameters a
;