Classe NumberedStoredProcedureParameter
The NumberedStoredProcedureParameter object represents a SQL Server numbered stored procedure parameter.
Hiérarchie d'héritage
System.Object
Microsoft.SqlServer.Management.Smo.SmoObjectBase
Microsoft.SqlServer.Management.Smo.SqlSmoObject
Microsoft.SqlServer.Management.Smo.NamedSmoObject
Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase
Microsoft.SqlServer.Management.Smo.ParameterBase
Microsoft.SqlServer.Management.Smo.Parameter
Microsoft.SqlServer.Management.Smo.NumberedStoredProcedureParameter
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
<SfcElementTypeAttribute("Param")> _
Public NotInheritable Class NumberedStoredProcedureParameter _
Inherits Parameter _
Implements ISfcSupportsDesignMode
'Utilisation
Dim instance As NumberedStoredProcedureParameter
[SfcElementTypeAttribute("Param")]
public sealed class NumberedStoredProcedureParameter : Parameter,
ISfcSupportsDesignMode
[SfcElementTypeAttribute(L"Param")]
public ref class NumberedStoredProcedureParameter sealed : public Parameter,
ISfcSupportsDesignMode
[<SealedAttribute>]
[<SfcElementTypeAttribute("Param")>]
type NumberedStoredProcedureParameter =
class
inherit Parameter
interface ISfcSupportsDesignMode
end
public final class NumberedStoredProcedureParameter extends Parameter implements ISfcSupportsDesignMode
Le type NumberedStoredProcedureParameter expose les membres suivants.
Constructeurs
Nom | Description | |
---|---|---|
NumberedStoredProcedureParameter() | Initializes a new instance of the NumberedStoredProcedureParameter class. | |
NumberedStoredProcedureParameter(NumberedStoredProcedure, String) | Initializes a new instance of the NumberedStoredProcedureParameter class for the specified numbered stored procedure and with the specified name. |
Haut de la page
Propriétés
Nom | Description | |
---|---|---|
DataType | Gets or sets the data type associated with the parameter. (hérité de ParameterBase.) | |
DefaultValue | Gets or sets the default value of the parameter. (hérité de Parameter.) | |
ExtendedProperties | Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property defined on the ParameterBase object. (hérité de ParameterBase.) | |
ID | Gets the ID value that uniquely identifies the parameter. (hérité de Parameter.) | |
IsOutputParameter | Gets or sets the Boolean property that specifies whether the parameter is an output parameter. | |
IsReadOnly | Gets or sets whether the parameter is read only. (hérité de Parameter.) | |
Name | Gets or sets a String value that specifies the name of the stored procedure parameter. (remplace ParameterBase.Name.) | |
Parent | Gets the NumberedStoredProcedure object that is the parent of the NumberedStoredProcedureParameter object. | |
Properties | Gets a collection of Property objects that represent the object properties. (hérité de SqlSmoObject.) | |
State | Gets the state of the referenced object. (hérité de SmoObjectBase.) | |
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (hérité de SqlSmoObject.) | |
UserData | Gets or sets user-defined data associated with the referenced object. (hérité de SmoObjectBase.) |
Haut de la page
Méthodes
Nom | Description | |
---|---|---|
Discover | Discovers a list of type Object. (hérité de SqlSmoObject.) | |
Equals | (hérité de Object.) | |
FormatSqlVariant | Formats an object as SqlVariant type. (hérité de SqlSmoObject.) | |
GetContextDB | Gets the context database that is associated with this object. (hérité de SqlSmoObject.) | |
GetDBName | Gets the database name that is associated with the object. (hérité de SqlSmoObject.) | |
GetHashCode | (hérité de Object.) | |
GetPropValue | Gets a property value of the SqlSmoObject object. (hérité de SqlSmoObject.) | |
GetPropValueOptional | Gets a property value of the SqlSmoObject object. (hérité de SqlSmoObject.) | |
GetPropValueOptionalAllowNull | Gets a property value of the SqlSmoObject object. (hérité de SqlSmoObject.) | |
GetServerObject | Gets the server of the SqlSmoObject object. (hérité de SqlSmoObject.) | |
GetType | (hérité de Object.) | |
Initialize() | Initializes the object and forces the properties be loaded. (hérité de SqlSmoObject.) | |
Initialize(Boolean) | Initializes the object and forces the properties be loaded. (hérité de SqlSmoObject.) | |
IsObjectInitialized | Verifies whether the object has been initialized. (hérité de SqlSmoObject.) | |
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (hérité de SqlSmoObject.) | |
MarkForDrop | Marks the foreign key to be dropped next time its parent object is altered by the Alter method. (hérité de ParameterBase.) | |
Refresh | Refreshes the ParameterBase object. (hérité de ParameterBase.) | |
SetParentImpl | Sets the parent of the SqlSmoObject to the newParent parameter. (hérité de SqlSmoObject.) | |
ToString | Returns a String that represents the referenced object. (hérité de SqlSmoObject.) | |
Validate | Validates the state of an object. (hérité de SmoObjectBase.) |
Haut de la page
Événements
Nom | Description | |
---|---|---|
PropertyChanged | Represents the event that occurs when a property is changed. (hérité de SqlSmoObject.) | |
PropertyMetadataChanged | Represents the event that occurs when property metadata changes. (hérité de SqlSmoObject.) |
Haut de la page
Implémentations d'interfaces explicites
Nom | Description | |
---|---|---|
IAlienObject.Discover | Discovers any dependencies. Ne faites pas directement référence à ce membre dans votre code. Il prend en charge l'infrastructure SQL Server. (hérité de SqlSmoObject.) | |
IAlienObject.GetDomainRoot | Returns the root of the domain. (hérité de SqlSmoObject.) | |
IAlienObject.GetParent | Gets the parent of this object. Ne faites pas directement référence à ce membre dans votre code. Il prend en charge l'infrastructure SQL Server. (hérité de SqlSmoObject.) | |
IAlienObject.GetPropertyType | Gets the type of the specified property. (hérité de SqlSmoObject.) | |
IAlienObject.GetPropertyValue | Gets the value of the specified property. (hérité de SqlSmoObject.) | |
IAlienObject.GetUrn | Gets the Unified Resource Name (URN) of the object. Ne faites pas directement référence à ce membre dans votre code. Il prend en charge l'infrastructure SQL Server. (hérité de SqlSmoObject.) | |
IAlienObject.Resolve | Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. (hérité de SqlSmoObject.) | |
IAlienObject.SetObjectState | Sets the object state to the specified SfcObjectState value. (hérité de SqlSmoObject.) | |
IAlienObject.SetPropertyValue | Sets the property value. (hérité de SqlSmoObject.) | |
ISfcPropertyProvider.GetPropertySet | Gets the interface reference to the set of properties of this object. (hérité de SqlSmoObject.) | |
ISfcSupportsDesignMode.IsDesignMode | Gets a Boolean value that specifies whether the stored procedure parameter supports design mode. |
Haut de la page
Notes
To get NumberedStoredProcedureParameter object properties, users can be a member of the public fixed server role.
To set NumberedStoredProcedureParameter object properties, users must have ALTER permission on the parent numbered stored procedure, or be a member of the db_owner fixed database role.
To create a numbered stored procedure, users must have CREATE PROCEDURE permission on the parent database, or be a member of the db_owner fixed database role.
To drop a numbered stored procedure parameter, users must have CONTROL permission on the parent numbered stored procedure, or be a member of the db_owner fixed database role.
Thread Safety
Tout membre statique public (Partagé dans Microsoft Visual Basic) de ce type est sûr dans le cadre des opérations à plusieurs threads. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.
Exemples
Création, modification et suppression des procédures stockées
Sécurité des threads
Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.
Voir aussi
Référence
Espace de noms Microsoft.SqlServer.Management.Smo