MetadataProviderUtils.GetStoredProcParameters 메서드
Retrieves the stored procedure parameters.
네임스페이스: Microsoft.SqlServer.Management.SqlParser.MetadataProvider
어셈블리: Microsoft.SqlServer.Management.SqlParser(Microsoft.SqlServer.Management.SqlParser.dll)
구문
‘선언
Public Shared Function GetStoredProcParameters ( _
storedProcText As String, _
metadataFactory As IMetadataFactory, _
dataTypeLookup As ISystemDataTypeLookup, _
collationInfo As CollationInfo, _
parseOptions As ParseOptions _
) As IMetadataOrderedCollection(Of IParameter)
‘사용 방법
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>
매개 변수
- storedProcText
유형: System.String
The stored procedure text.
- metadataFactory
유형: Microsoft.SqlServer.Management.SqlParser.MetadataProvider.IMetadataFactory
The IMetadataFactory object that is used to create metadata objects.
- dataTypeLookup
유형: Microsoft.SqlServer.Management.SqlParser.MetadataProvider.ISystemDataTypeLookup
The ISystemDataTypeLookup object that is used to search for available system data types.
- collationInfo
유형: Microsoft.SqlServer.Management.SqlParser.Metadata.CollationInfo
The CollationInfo object that represents the collation of the related database.
- parseOptions
유형: Microsoft.SqlServer.Management.SqlParser.Parser.ParseOptions
The parsing options.
반환 값
유형: Microsoft.SqlServer.Management.SqlParser.Metadata.IMetadataOrderedCollection<IParameter>
An ordered collection of parameters; nullnull 참조(Visual Basic에서는 Nothing) if no parameters are present.
참고 항목
참조
Microsoft.SqlServer.Management.SqlParser.MetadataProvider 네임스페이스