StoredProcedureParameter Constructor (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 (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Sub New ( _
storedProcedure As StoredProcedure, _
name As String, _
dataType As DataType _
)
'Usage
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
)
Parameters
- storedProcedure
Type: Microsoft.SqlServer.Management.Smo.StoredProcedure
A StoredProcedure object value that specifies the stored procedure on which the parameter is defined.
- name
Type: System.String
A String value that specifies the name of the stored procedure parameter.
- dataType
Type: Microsoft.SqlServer.Management.Smo.DataType
A DataType system object value that specifies the data type of the stored procedure parameter.
Examples
Creating, Altering, and Removing Stored Procedures
See Also
Reference
StoredProcedureParameter Class