• Article

StoredProcedure.Parameters Property

Represents a collection of StoredProcedureParameterCollection objects. Each StoredProcedureParameter object represents a parameter defined for the stored procedure.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.ZeroToAny,  _
    GetType(StoredProcedureParameter))> _
Public ReadOnly Property Parameters As StoredProcedureParameterCollection
    Get
'Usage
Dim instance As StoredProcedure
Dim value As StoredProcedureParameterCollection

value = instance.Parameters

[SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.ZeroToAny, 
    typeof(StoredProcedureParameter))]
public StoredProcedureParameterCollection Parameters { get; }

[SfcObjectAttribute(SfcContainerRelationship::ChildContainer, SfcContainerCardinality::ZeroToAny, 
    typeof(StoredProcedureParameter))]
public:
property StoredProcedureParameterCollection^ Parameters {
    StoredProcedureParameterCollection^ get ();
}

[<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.ZeroToAny, 
    typeof(StoredProcedureParameter))>]
member Parameters : StoredProcedureParameterCollection

function get Parameters () : StoredProcedureParameterCollection

Property Value

Type: Microsoft.SqlServer.Management.Smo.StoredProcedureParameterCollection
A StoredProcedureParameterCollection object that represents all the parameter defined for the stored procedure.