SQL Reference (SQL Server Compact)

SQL Server Compact 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 supports only the Transact-SQL grammar documented in this section. SQL Reference for SQL Server Compact is a subset of Transact-SQL for SQL Server.

For information about

See

Syntax conventions and query elements

SQL Overview (SQL Server Compact)

Data types

Data Types

Functions

Functions (SQL Server Compact)

Information schema views

Information Schema (SQL Server Compact)

Operators

Operators (SQL Server Compact)

Reserved words

Reserved Words (SQL Server Compact)

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.

See Also

Other Resources

SQL Server Compact Samples