Defines the type of the parameters available to use in the SQL statement that the Execute SQL task runs.
命名空间: Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask
程序集: Microsoft.SqlServer.SQLTask (in microsoft.sqlserver.sqltask.dll)
语法
声明
<FlagsAttribute> _
Public Enumeration ParameterDirections
[FlagsAttribute]
public enum ParameterDirections
[FlagsAttribute]
public enum class ParameterDirections
/** @attribute FlagsAttribute() */
public enum ParameterDirections
FlagsAttribute
public enum ParameterDirections
Members
Member name | Description |
---|---|
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. For more information about parameters, see 参数(数据库引擎) and 使用 OUTPUT 参数返回数据.
平台
开发平台
有关支持的平台列表,请参阅安装 SQL Server 2005 的硬件和软件要求。
目标平台
有关支持的平台列表,请参阅安装 SQL Server 2005 的硬件和软件要求。