Querying Databases (SQL Server Compact)

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

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

Section Description

Using SQL Grammar

Describes how to use SQL syntax to query a database.

Using Query Tools (SQL Server Compact)

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

Using Programming Interfaces

Describes the process of querying a database by using APIs.