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.

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.

Show: