A SQL Server CE database can be populated by using SQL DML statements. SQL Server CE 2.0 supports a subset of the DML statement that is supported by SQL Server. The supported commands are listed in Table 7.7. See the Microsoft SQL Server CE 2.0 Books Online to learn more about the DML statements.
|INSERT||Adds a new row to a table.|
|UPDATE||Modifies existing data in a table.|
|DELETE||Removes rows from a table.|
|SELECT||Retrieves rows from the database and allows the selection of one or many rows or columns from one or many tables. The SELECT statement supports inner and outer joins, and the Order By, Group By, and Having clauses.|
SQL Server CE ...