NumberedStoredProcedureParameter Class
The NumberedStoredProcedureParameter object represents a Microsoft SQL Server numbered stored procedure parameter.
Espace de noms: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntaxe
'Déclaration
Public NotInheritable Class NumberedStoredProcedureParameter
Inherits Parameter
public sealed class NumberedStoredProcedureParameter : Parameter
public ref class NumberedStoredProcedureParameter sealed : public Parameter
public final class NumberedStoredProcedureParameter extends Parameter
public final class NumberedStoredProcedureParameter extends Parameter
Notes
Cet espace de noms, cette classe ou ce membre est pris en charge uniquement par la version 2.0 de Microsoft .NET Framework.
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.
Inheritance Hierarchy
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
Exemple
How to: Create, Alter, and Remove a Stored Procedure in Visual Basic .NET
Sécurité des threads
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Plateformes
Plateformes de développement
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.
Plateformes cibles
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.
Voir aussi
Référence
NumberedStoredProcedureParameter Members
Microsoft.SqlServer.Management.Smo Namespace
Autres ressources
Creating, Altering, and Removing Stored Procedures
ALTER PROCEDURE (Transact-SQL)