Microsoft SQL Server Compact 3.5 supports Data Manipulation Language (DML) statements.
Supported DML Statements
The following tables lists the DML statements that SQL Server Compact 3.5 supports.
Statement |
Function |
---|---|
INSERT |
Adds a new row to a table. |
UPDATE |
Changes existing data in a table. |
DELETE |
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.