Partilhar via


Interface IStoredProcedure

Represents a SQL Server stored procedure. 

Namespace:  Microsoft.SqlServer.Management.SqlParser.Metadata
Assembly:  Microsoft.SqlServer.Management.SqlParser (em Microsoft.SqlServer.Management.SqlParser.dll)

Sintaxe

'Declaração
Public Interface IStoredProcedure _
    Inherits ICallableModule, IUserDefinedFunctionModuleBase, ISchemaOwnedObject, IDatabaseObject,  _
    IFunctionModuleBase, IMetadataObject
'Uso
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

O tipo IStoredProcedure expõe os membros a seguir.

Propriedades

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

Início