共用方式為


IStoredProcedure 介面

Represents a SQL Server stored procedure. 

命名空間:  Microsoft.SqlServer.Management.SqlParser.Metadata
組件:  Microsoft.SqlServer.Management.SqlParser (在 Microsoft.SqlServer.Management.SqlParser.dll 中)

語法

'宣告
Public Interface IStoredProcedure _
    Inherits ICallableModule, IUserDefinedFunctionModuleBase, ISchemaOwnedObject, IDatabaseObject,  _
    IFunctionModuleBase, IMetadataObject
'用途
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

IStoredProcedure 型別公開下列成員。

屬性

  名稱 說明
公用屬性 BodyText Gets the Transact-SQL statements that define the module.
公用屬性 ExecutionContext Gets the IExecutionContext object that specifies the module execution context. (繼承自 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. (繼承自 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. (繼承自 IDatabaseObject。)
公用屬性 ModuleType Gets the module type. (繼承自 ICallableModule。)
公用屬性 Name Gets the name of the metadata object. (繼承自 IMetadataObject。)
公用屬性 Parameters Gets a collection that contains the parameters that the function or module accepts. (繼承自 IFunctionModuleBase。)
公用屬性 Parent Gets the IDatabaseObject object that is the parent of this object. (繼承自 IDatabaseObject。)
公用屬性 ReturnType Gets the scalar data type of the module return value. (繼承自 ICallableModule。)
公用屬性 Schema Gets the ISchema object that owns this object. (繼承自 ISchemaOwnedObject。)
公用屬性 Startup Gets a value that specifies whether the stored procedure runs when the instance of SQL Server starts up.

上層