Result Set En Sql. In other words it contains the rows that satisfy the conditions of the query. Can be used with multiple result sets returned by queries to change the column names and data types at runtime.
In default the cursor positions before the first row of the result data. It can be used to specify alternate data types and column names for result sets returned by an EXECUTED statement or Stored Procedure. When the SQL statement generates multiple rows such as a SELECT command XML.
A ResultSet object maintains a cursor that points to the current row in the result set.
Uses of Execute WITH RESULT SETS in SQL Server. By using the SQLServerResultSet object you can retrieve the data returned from an SQL statement or stored procedure update the data as needed and then persist that data back to the database. SQL Server 2012 introduced a RESULT SET clause to the EXECUTE statement. When the SQL statement generates multiple rows such as a SELECT command XML.