此 API 支援 SQL Server 2012 基礎結構,但無法直接從您的程式碼使用。
Defines the properties for the Execute SQL task.
命名空間: Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask
組件: Microsoft.SqlServer.SQLTask (在 Microsoft.SqlServer.SQLTask.dll 中)
語法
'宣告
Public Interface IDTSExecuteSQL
'用途
Dim instance As IDTSExecuteSQL
public interface IDTSExecuteSQL
public interface class IDTSExecuteSQL
type IDTSExecuteSQL = interface end
public interface IDTSExecuteSQL
IDTSExecuteSQL 型別公開下列成員。
屬性
| 名稱 | 說明 | |
|---|---|---|
![]() |
BypassPrepare | 基礎結構。Gets or sets a value that indicates whether the Execute SQL task skips preparation of the statement when sending the SQL statement to the relational database management system (RDBMS). |
![]() |
CodePage | 基礎結構。Gets or sets the code page to use when translating variable values that are stored as Unicode wide chars to multi-bytes. |
![]() |
Connection | 基礎結構。Gets or sets the name of the connection manager for the Execute SQL task. |
![]() |
IsStoredProcedure | 基礎結構。Gets or sets a value that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure. |
![]() |
ParameterBindings | 基礎結構。Gets an object that implements IDTSParameterBindings interface. |
![]() |
ResultSetBindings | 基礎結構。Gets an object that implements IDTSResultBindings interface. |
![]() |
ResultSetType | 基礎結構。Gets or sets the type of result set returned by the SQL statement that the Execute SQL task runs. |
![]() |
SqlStatementSource | 基礎結構。Gets or sets the name of the source that contains the SQL statement that the Execute SQL task runs. |
![]() |
SqlStatementSourceType | 基礎結構。Gets or sets the type of source that contains the SQL statement that the Execute SQL task runs. |
![]() |
TimeOut | 基礎結構。Gets or sets the maximum number of seconds the task can run before timing out. |
上層
.gif)