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 | |
---|---|---|
BodyText | Gets the Transact-SQL statements that define the module. | |
ExecutionContext | Gets the IExecutionContext object that specifies the module execution context. (Geerbt von IUserDefinedFunctionModuleBase.) | |
ForReplication | Gets a value that indicates whether the stored procedure is available for replication. | |
IsEncrypted | Gets a value that indicates whether the module is encrypted. (Geerbt von IUserDefinedFunctionModuleBase.) | |
IsQuotedIdentifierOn | Gets a Boolean value that indicates whether the quoted identifier option is on. | |
IsRecompiled | Gets a value that indicates whether the stored procedure is recompiled before execution. | |
IsSqlClr | Gets a value that indicates whether this is a CLR module. | |
IsSystemObject | Gets a value that indicates whether this is a system object. (Geerbt von IDatabaseObject.) | |
ModuleType | Gets the module type. (Geerbt von ICallableModule.) | |
Name | Gets the name of the metadata object. (Geerbt von IMetadataObject.) | |
Parameters | Gets a collection that contains the parameters that the function or module accepts. (Geerbt von IFunctionModuleBase.) | |
Parent | Gets the IDatabaseObject object that is the parent of this object. (Geerbt von IDatabaseObject.) | |
ReturnType | Gets the scalar data type of the module return value. (Geerbt von ICallableModule.) | |
Schema | Gets the ISchema object that owns this object. (Geerbt von ISchemaOwnedObject.) | |
Startup | Gets a value that specifies whether the stored procedure runs when the instance of SQL Server starts up. |
Zum Anfang
Methoden
Name | Beschreibung | |
---|---|---|
Accept< (Of < <' (T> ) > > )(IDatabaseObjectVisitor< (Of < <' (T> ) > > )) | Accepts a visit from the specified IDatabaseObjectVisitor<(Of <(<'T>)>)> object. (Geerbt von IDatabaseObject.) | |
Accept< (Of < <' (T> ) > > )(IMetadataObjectVisitor< (Of < <' (T> ) > > )) | Accepts a visit from the specified IMetadataObjectVisitor<(Of <(<'T>)>)> object. (Geerbt von IMetadataObject.) | |
Accept< (Of < <' (T> ) > > )(ISchemaOwnedObjectVisitor< (Of < <' (T> ) > > )) | Accepts a visit from the specified ISchemaOwnedObjectVisitor<(Of <(<'T>)>)> object. (Geerbt von ISchemaOwnedObject.) |
Zum Anfang