This documentation is archived and is not being maintained.
Accessing and Changing Database Data
SQL Server 2008 R2
To access and change database data requires understanding the fundamental aspects of building and executing Transact-SQL statements and processing results in the form of relational, or tabular, result sets.
The topics in this section provide information to help you retrieve data from and modify data in Microsoft SQL Server tables.
Describes how to manipulate and control the results of queries by combining result sets and views, working with temporary result sets, producing summary reports of result sets, and sending notifications when result sets change.
Describes how SELECT statements always return a set of rows, but applications sometimes need to go through the result set one row at a time. Cursors support processing a result set one row, or a block of rows, at a time.