SQL Server Compact 3.5 includes Transact-SQL grammar that you can use to query a database and to insert, update, and delete data in tables in a database. The topics in this section describe Transact-SQL grammar and the items listed in the following table.
SQL Server Compact 3.5 supports only the Transact-SQL grammar documented in this section. SQL Reference for SQL Server Compact 3.5 is a subset of Transact-SQL for SQL Server.
For information about
Syntax conventions and query elements
Information schema views
SQL Server Compact 3.5 also includes SQL Server Compact 3.5 Query Analyzer, a tool you can use to query tables in a database. For more information, see SQL Server Compact Query Analyzer.
The examples in the reference topics are not case sensitive. For more information about SQL grammar and Transact-SQL usage and examples, see SQL Server Books Online.