Accessing and Changing Data contains information about how you use Transact-SQL with SQL Server, either when entering Transact-SQL statements in a utility or Transact-SQL script, or when coding an application.
| Topic | Description |
|---|---|
| Query Tools and Programming Interfaces | Describes the different classes of tools used to work with SQL Server. Outlines how Transact-SQL interfaces with utilities and database APIs. |
| Transact-SQL Syntax Elements | Describes the primary syntax elements used in Transact-SQL statements. |
| Accessing and Changing Data Fundamentals | Describes fundamental issues not specific to a Transact-SQL statement: Choosing a database Using Transact-SQL batches and scripts Using variables and parameters Controlling the flow of logic Understanding permissions |
| Query Fundamentals | Describes the main clauses used in the SELECT, INSERT, DELETE, and UPDATE statements: Select list FROM clause WHERE clause ORDER BY clause JOIN clauses |
| Advanced Query Concepts | Describes advanced concepts such as: Using aggregate functions Using GROUP BY and UNION Subqueries Summarizing data Error handling Full-text querying Distributed queries |
| Adding Data | Describes the methods for inserting new rows. |
| Changing Data | Describes the methods for updating existing data values. |
| Deleting Data | Describes the methods for deleting data rows. |
| Transactions | Describes how several data modification statements can be grouped in a transaction. |
| Cursors | 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. |
| Locking | Describes how SQL Server prevents multiple users from modifying the same data at the same time. |