Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
Important
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.