Partager via


Interface IStoredProcedure

Represents a SQL Server stored procedure. 

Espace de noms :  Microsoft.SqlServer.Management.SqlParser.Metadata
Assembly :  Microsoft.SqlServer.Management.SqlParser (en Microsoft.SqlServer.Management.SqlParser.dll)

Syntaxe

'Déclaration
Public Interface IStoredProcedure _
    Inherits ICallableModule, IUserDefinedFunctionModuleBase, ISchemaOwnedObject, IDatabaseObject,  _
    IFunctionModuleBase, IMetadataObject
'Utilisation
Dim instance As IStoredProcedure
public interface IStoredProcedure : ICallableModule, 
    IUserDefinedFunctionModuleBase, ISchemaOwnedObject, IDatabaseObject, IFunctionModuleBase, IMetadataObject
public interface class IStoredProcedure : ICallableModule, 
    IUserDefinedFunctionModuleBase, ISchemaOwnedObject, IDatabaseObject, IFunctionModuleBase, IMetadataObject
type IStoredProcedure =  
    interface
        interface ICallableModule
        interface IUserDefinedFunctionModuleBase
        interface ISchemaOwnedObject
        interface IDatabaseObject
        interface IFunctionModuleBase
        interface IMetadataObject
    end
public interface IStoredProcedure extends ICallableModule, IUserDefinedFunctionModuleBase, ISchemaOwnedObject, IDatabaseObject, IFunctionModuleBase, IMetadataObject

Le type IStoredProcedure expose les membres suivants.

Propriétés

  Nom Description
Propriété publique BodyText Gets the Transact-SQL statements that define the module.
Propriété publique ExecutionContext Gets the IExecutionContext object that specifies the module execution context. (hérité de IUserDefinedFunctionModuleBase.)
Propriété publique ForReplication Gets a value that indicates whether the stored procedure is available for replication.
Propriété publique IsEncrypted Gets a value that indicates whether the module is encrypted. (hérité de IUserDefinedFunctionModuleBase.)
Propriété publique IsQuotedIdentifierOn Gets a Boolean value that indicates whether the quoted identifier option is on.
Propriété publique IsRecompiled Gets a value that indicates whether the stored procedure is recompiled before execution.
Propriété publique IsSqlClr Gets a value that indicates whether this is a CLR module.
Propriété publique IsSystemObject Gets a value that indicates whether this is a system object. (hérité de IDatabaseObject.)
Propriété publique ModuleType Gets the module type. (hérité de ICallableModule.)
Propriété publique Name Gets the name of the metadata object. (hérité de IMetadataObject.)
Propriété publique Parameters Gets a collection that contains the parameters that the function or module accepts. (hérité de IFunctionModuleBase.)
Propriété publique Parent Gets the IDatabaseObject object that is the parent of this object. (hérité de IDatabaseObject.)
Propriété publique ReturnType Gets the scalar data type of the module return value. (hérité de ICallableModule.)
Propriété publique Schema Gets the ISchema object that owns this object. (hérité de ISchemaOwnedObject.)
Propriété publique Startup Gets a value that specifies whether the stored procedure runs when the instance of SQL Server starts up.

Haut de la page