Construtor StoredProcedureParameter (StoredProcedure, String, DataType)

Initializes a new instance of the StoredProcedureParameter class for the specified stored procedure and with the specified name and data type.

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

Sintaxe

'Declaração
Public Sub New ( _
    storedProcedure As StoredProcedure, _
    name As String, _
    dataType As DataType _
)
'Uso
Dim storedProcedure As StoredProcedure 
Dim name As String 
Dim dataType As DataType 

Dim instance As New StoredProcedureParameter(storedProcedure, _
    name, dataType)

public StoredProcedureParameter(
    StoredProcedure storedProcedure,
    string name,
    DataType dataType
)

public:
StoredProcedureParameter(
    StoredProcedure^ storedProcedure, 
    String^ name, 
    DataType^ dataType
)

new : 
        storedProcedure:StoredProcedure * 
        name:string * 
        dataType:DataType -> StoredProcedureParameter

public function StoredProcedureParameter(
    storedProcedure : StoredProcedure, 
    name : String, 
    dataType : DataType
)

Parâmetros

• storedProcedure
  Tipo: Microsoft.SqlServer.Management.Smo.StoredProcedure
  A StoredProcedure object value that specifies the stored procedure on which the parameter is defined.

• name
  Tipo: System.String
  A String value that specifies the name of the stored procedure parameter.

• dataType
  Tipo: Microsoft.SqlServer.Management.Smo.DataType
  A DataType system object value that specifies the data type of the stored procedure parameter.

Exemplos

Criando, alterando e removendo procedimentos armazenados

Consulte também

Referência

StoredProcedureParameter Classe

Sobrecarregado StoredProcedureParameter

Namespace Microsoft.SqlServer.Management.Smo