Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
DML Statements (SQL Server Compact)
Collapse the table of content
Expand the table of content

DML Statements (SQL Server Compact)

Microsoft SQL Server Compact supports Data Manipulation Language (DML) statements.

The following tables lists the DML statements that SQL Server Compact 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. Brackets are not supported.

Show:
© 2015 Microsoft