Microsoft® .NET Compact Framework Kick Start

Populating a Microsoft SQL Server CE Database

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.

Table 7.7. DML Statements Supported by SQL Server CE

STATEMENT	FUNCTION
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 ...