Defines the type of the parameters available to use in the SQL statement that the Execute SQL task runs.
此列舉有一個允許其成員值為位元組合的 FlagsAttribute 屬性。
命名空間: Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask
組件: Microsoft.SqlServer.SQLTask (在 Microsoft.SqlServer.SQLTask.dll 中)
語法
'宣告
<FlagsAttribute> _
Public Enumeration ParameterDirections
'用途
Dim instance As ParameterDirections
[FlagsAttribute]
public enum ParameterDirections
[FlagsAttribute]
public enum class ParameterDirections
[<FlagsAttribute>]
type ParameterDirections
public enum ParameterDirections
成員
| 成員名稱 | 說明 | |
|---|---|---|
| Input | The parameter is an input parameter that passes a value to the SQL statement. | |
| Output | The parameter is an output parameter that returns a value to the Execute SQL task. | |
| ReturnValue | The parameter is a return code that returns an integer value from a stored procedure to the Execute SQL task. |
備註
Parameters are used to exchange data between the Execute SQL task and the queries or stored procedures it calls.