| title | Working with result sets |
|---|---|
| description | Learn how to work with data using result sets in the JDBC Driver for SQL Server in these sample applications. |
| author | David-Engel |
| ms.author | davidengel |
| ms.date | 08/12/2019 |
| ms.service | sql |
| ms.subservice | connectivity |
| ms.topic | how-to |
[!INCLUDEDriver_JDBC_Download]
When you work with the data contained in a [!INCLUDEssNoVersion] database, one method of manipulating the data is to use a result set. The [!INCLUDEjdbcNoVersion] supports the use of result sets through the SQLServerResultSet object. By using the SQLServerResultSet object, you can retrieve the data returned from a SQL statement or stored procedure, update the data as needed, and then persist that data back to the database.
In addition, the SQLServerResultSet object provides methods for navigating through its rows of data, getting or setting the data that it contains, and for establishing various levels of sensitivity to changes in the underlying database.
Note
For more information about managing result sets, including their sensitivity to changes, see Managing result sets with the JDBC driver.
The topics in this section describe different ways that you can use a result set to manipulate the data contained in a [!INCLUDEssNoVersion] database.
| Topic | Description |
|---|---|
| Retrieving result set data sample | Describes how to use a result set to retrieve data from a [!INCLUDEssNoVersion] database and display it. |
| Modifying result set data sample | Describes how to use a result set to insert, retrieve, and modify data in a [!INCLUDEssNoVersion] database. |
| Caching result set data sample | Describes how to use a result set to retrieve large amounts of data from a [!INCLUDEssNoVersion] database, and to control how that data is cached on the client. |