Querying Databases (SQL Server Compact Edition)

Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) supports querying its databases by using various query tools and APIs.

In This Section

The topics in this section provide an overview of how to query SQL Server Compact Edition databases.

Section Description

Using SQL Grammar

Describes how to use SQL syntax to query a database.

Using Query Tools (SQL Server Compact Edition)

Explains the two tools, SQL Server Management Studio and SQL Server Compact Edition Query Analyzer, that can be used to query a SQL Server Compact Edition database.

Using Programming Interfaces

Describes the process of querying a database by using APIs.