Freigeben über


IStoredProcedure-Schnittstelle

Represents a SQL Server stored procedure. 

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

Syntax

'Declaration
Public Interface IStoredProcedure _
    Inherits ICallableModule, IUserDefinedFunctionModuleBase, ISchemaOwnedObject, IDatabaseObject,  _
    IFunctionModuleBase, IMetadataObject
'Usage
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

Der IStoredProcedure-Typ macht folgende Elemente verfügbar.

Eigenschaften

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

Zum Anfang