Partager via

  • Article

Classe NumberedStoredProcedureParameter

The NumberedStoredProcedureParameter object represents a SQL Server numbered stored procedure parameter.

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (dans Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
<SfcElementTypeAttribute("Param")> _
Public NotInheritable Class NumberedStoredProcedureParameter _
    Inherits Parameter
'Utilisation
Dim instance As NumberedStoredProcedureParameter

[SfcElementTypeAttribute("Param")]
public sealed class NumberedStoredProcedureParameter : Parameter

[SfcElementTypeAttribute(L"Param")]
public ref class NumberedStoredProcedureParameter sealed : public Parameter

[<SealedAttribute>]
[<SfcElementTypeAttribute("Param")>]
type NumberedStoredProcedureParameter =  
    class
        inherit Parameter
    end

public final class NumberedStoredProcedureParameter extends Parameter

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 sûrs.

Sécurité des threads

Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Il n'est pas garanti que les membres d'instance soient thread-safe.