Export (0) Print
Expand All

Working with Result Sets

When you work with the data contained in a SQL Server database, one method of manipulating the data is to use a result set. The Microsoft JDBC Driver for SQL Server supports the use of result sets through the SQLServerResultSet object. 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. 

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 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 SQL Server database.

Topic

Description

Retrieving Result Set Data Sample

Describes how to use a result set to retrieve data from a SQL Server database and display it.

Modifying Result Set Data Sample

Describes how to use a result set to insert, retrieve, and modify data in a SQL Server database.

Caching Result Set Data Sample

Describes how to use a result set to retrieve large amounts of data from a SQL Server database, and to control how that data is cached on the client.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft