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 |
See |
|---|---|
Syntax conventions and query elements |
|
Data types |
|
Functions |
|
Information schema views |
|
Operators |
|
Reserved words |
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.