Querying and Changing Data (Database Engine)

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

In This Section

• 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.