3 out of 5 rated this helpful - Rate this topic

Querying and Changing Data (Database Engine)

SQL Server 2008 R2

Other Versions

This section describes the SQL Server objects and components that you can use to access and change data.

Accessing and Changing Database Data: Describes the fundamental aspects of building and executing Transact-SQL statements and processing results in the form of relational, or tabular, result sets.
Stored Procedures (Database Engine): Provides the information necessary to understand, design, and implement stored procedures.
DML Triggers: Provides the information necessary to understand, design, and implement DML triggers.
User-Defined Functions (Database Engine): Provides the information necessary to understand, design, and implement user-defined functions.
International Considerations for Databases and Database Engine Applications: Describes how to store and manipulate multilingual data.
Full-Text Search (SQL Server): Provides the information necessary to understand, design, and implement full-text search.
Querying the SQL Server System Catalog: Describes the system objects that show the metadata that describes the objects in an instance of SQL Server.
SQL Dependencies: Describes how to understand and report on dependencies between SQL entities.
Tracking Data Changes: Describes how to use change data capture and change tracking to enable applications to query for only the data that has changed.
Querying and Changing Data How-to Topics: Contains procedures that describe how to use the tools and objects provided in the Database Engine to query and change data.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions