NumberedStoredProcedure.Parameters Property

Represents a collection of NumberedStoredProcedureParameter objects. Each NumberedStoredProcedureParameter object represents a parameter defined for the numbered stored procedure.

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

Syntax

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

value = instance.Parameters

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

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

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

function get Parameters () : NumberedStoredProcedureParameterCollection

Property Value

Type: Microsoft.SqlServer.Management.Smo.NumberedStoredProcedureParameterCollection
A NumberedStoredProcedureParameterCollection object that represents all the parameters defined for the numbered stored procedure.

Examples

Creating, Altering, and Removing Stored Procedures

See Also

Reference

NumberedStoredProcedure Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

CREATE PROCEDURE (Transact-SQL)