Using SQL Grammar

  • Article

Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) includes SQL grammar that you can use to query a database, modify a database, or modify data in a database.

Queries that can typically be run on SQL Server Compact Edition can also run on Microsoft SQL Server; however, many of the features of Transact-SQL are absent from SQL Server Compact Edition, and only a single SQL statement can be executed in a command.

SQL Server Compact Edition supports parameterized queries in which parameters are delimited with the question mark (?) character. It also supports named parameterized queries through ADO .NET.

Note

SQL Server Compact Edition does not support scripting because scripting depends on SQL Server Management Objects (SMO). SMO is not a feature of SQL Server Compact Edition.

For more information about the query grammar supported by SQL Server Compact Edition, see SQL Reference (SQL Server Compact Edition).