Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Lesson 3: Executing queries against a Windows CE database

One of the principal uses of Interactive SQL is to browse table data. Interactive SQL retrieves information by sending a request to your database server. The database server, in turn, looks up the information, and returns it to Interactive SQL.

To execute a SQL statement against a Windows CE database

1. Type the following in the SQL Statements pane:

   SELECT * FROM Employees

2. Click Execute SQL Statement, or choose SQL > Execute, or press F5 to execute the statement.

   All the data from the Employees table appears in the Results pane.

3. Choose SQL > Disconnect or press F12 to disconnect from the Windows CE database.

Once you connect to a database from Interactive SQL, you can view and manipulate the dat, as well as add and modify database objects.

For information about Interactive SQL, writing queries, and using SQL statements, see:

• Interactive SQL
• Queries: Selecting Data from a Table
• Summarizing, Grouping, and Sorting Query Results
• Joins: Retrieving Data from Several Tables
• SQL Statements