MetadataProviderUtils.GetStoredProcParameters Method
Retrieves the stored procedure parameters.
Namespace: Microsoft.SqlServer.Management.SqlParser.MetadataProvider
Assembly: Microsoft.SqlServer.Management.SqlParser (in Microsoft.SqlServer.Management.SqlParser.dll)
Syntax
'Declaration
Public Shared Function GetStoredProcParameters ( _
storedProcText As String, _
metadataFactory As IMetadataFactory, _
dataTypeLookup As ISystemDataTypeLookup, _
collationInfo As CollationInfo, _
parseOptions As ParseOptions _
) As IMetadataOrderedCollection(Of IParameter)
'Usage
Dim storedProcText As String
Dim metadataFactory As IMetadataFactory
Dim dataTypeLookup As ISystemDataTypeLookup
Dim collationInfo As CollationInfo
Dim parseOptions As ParseOptions
Dim returnValue As IMetadataOrderedCollection(Of IParameter)
returnValue = MetadataProviderUtils.GetStoredProcParameters(storedProcText, _
metadataFactory, dataTypeLookup, _
collationInfo, parseOptions)
public static IMetadataOrderedCollection<IParameter> GetStoredProcParameters(
string storedProcText,
IMetadataFactory metadataFactory,
ISystemDataTypeLookup dataTypeLookup,
CollationInfo collationInfo,
ParseOptions parseOptions
)
public:
static IMetadataOrderedCollection<IParameter^>^ GetStoredProcParameters(
String^ storedProcText,
IMetadataFactory^ metadataFactory,
ISystemDataTypeLookup^ dataTypeLookup,
CollationInfo^ collationInfo,
ParseOptions^ parseOptions
)
static member GetStoredProcParameters :
storedProcText:string *
metadataFactory:IMetadataFactory *
dataTypeLookup:ISystemDataTypeLookup *
collationInfo:CollationInfo *
parseOptions:ParseOptions -> IMetadataOrderedCollection<IParameter>
public static function GetStoredProcParameters(
storedProcText : String,
metadataFactory : IMetadataFactory,
dataTypeLookup : ISystemDataTypeLookup,
collationInfo : CollationInfo,
parseOptions : ParseOptions
) : IMetadataOrderedCollection<IParameter>
Parameters
- storedProcText
Type: System.String
The stored procedure text.
- metadataFactory
Type: Microsoft.SqlServer.Management.SqlParser.MetadataProvider.IMetadataFactory
The IMetadataFactory object that is used to create metadata objects.
- dataTypeLookup
Type: Microsoft.SqlServer.Management.SqlParser.MetadataProvider.ISystemDataTypeLookup
The ISystemDataTypeLookup object that is used to search for available system data types.
- collationInfo
Type: Microsoft.SqlServer.Management.SqlParser.Metadata.CollationInfo
The CollationInfo object that represents the collation of the related database.
- parseOptions
Type: Microsoft.SqlServer.Management.SqlParser.Parser.ParseOptions
The parsing options.
Return Value
Type: Microsoft.SqlServer.Management.SqlParser.Metadata.IMetadataOrderedCollection<IParameter>
An ordered collection of parameters; nulla null reference (Nothing in Visual Basic) if no parameters are present.