Using SQL Grammar
Microsoft SQL Server Compact 4.0 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 4.0 can also run on Microsoft SQL Server; however, many of the features of Transact-SQL are absent from SQL Server Compact 4.0, and only a single SQL statement can be executed in a command.
SQL Server Compact 4.0 supports parameterized queries in which parameters are delimited with the question mark (?) character. It also supports named parameterized queries through ADO .NET.
For more information about the query grammar supported by SQL Server Compact 4.0, see SQL Reference (SQL Server Compact).