ResultSetType Enumeration
Defines the type of result set that the Execute SQL task can use.
Assembly: Microsoft.SqlServer.SQLTask (in Microsoft.SqlServer.SQLTask.dll)
| Member name | Description | |
|---|---|---|
| ResultSetType_None | Specifies that the SQL statement does not return a result set. For example, this result set is used for queries that add, change, or delete records in a table. | |
| ResultSetType_Rowset | Specifies that the result set has multiple rows. For example, this result set is used for a SELECT statement that retrieves all the rows in a table. | |
| ResultSetType_SingleRow | Specifies that the result set is a single row. For example, this result set is used for a stored procedure that returns a return code or a SELECT statement that returns a count or a sum. | |
| ResultSetType_XML | Specifies that an XML result set is used when the query returns a result set in an XML format. For example, this result set is used for a SELECT statement that includes a FOR XML clause. |
The following example creates an ExecuteSQLTask, then shows the default settings of the properties. It then sets the value of some properties, including the ResultSetType which uses this enumeration, to show how to set property values.
Sample Output:
BypassPrepare False
CodePage
Connection
ExecutionValue
IsStoredProcedure False
ParameterBindings Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ParameterBindings
ResultSetBindings Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ResultBindings
ResultSetType 1
SqlStatementSource
SqlStatementSourceType 1
TimeOut 0
--------------------------
New value of Source and SourceType: myVar, 3
New value of ResultSetType: 4