Aracılığıyla paylaş

StoredProcedure.Parameters Property

  • Makale

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

'Bildirim
<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.ZeroToAny,  _
    GetType(StoredProcedureParameter), SfcObjectFlags.None Or SfcObjectFlags.NaturalOrder Or SfcObjectFlags.Design)> _
Public ReadOnly Property Parameters As StoredProcedureParameterCollection
    Get
'Kullanım
Dim instance As StoredProcedure
Dim value As StoredProcedureParameterCollection

value = instance.Parameters

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

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

[<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.ZeroToAny, 
    typeof(StoredProcedureParameter), SfcObjectFlags.None|SfcObjectFlags.NaturalOrder|SfcObjectFlags.Design)>]
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.

Examples

Creating, Altering, and Removing Stored Procedures

See Also

Reference

StoredProcedure Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

CREATE PROCEDURE (Transact-SQL)