Microsoft SQL Server Compact 3.5 supports Data Manipulation Language (DML) statements.
The following tables lists the DML statements that SQL Server Compact 3.5 supports.
Adds a new row to a table.
Changes existing data in a table.
Removes rows from a table.
To delimit identifiers that are keywords or do not conform to the rules for identifiers, you must use double quotation marks in SQL Server Compact 3.5. Brackets are not supported.