O'Reilly logo

Microsoft® .NET Compact Framework Kick Start by Ronnie Yates, Erik Rubin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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
STATEMENTFUNCTION
INSERTAdds a new row to a table.
UPDATEModifies existing data in a table.
DELETERemoves rows from a table.
SELECTRetrieves 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required