Run SQL Queries

Now you will use the basic knowledge of SQL queries acquired in the previous lab and include an additional line specifying the retrieval mode.

Step 1. In the SQL Server Management Studio, verify that you are connected to your Historian Server and the Runtime database is selected.

Step 2. On the File menu, click Open | File. The Open File dialog box appears.

Step 3. Download file and, select Lab7-Using Retrieval Options.sql and click Open.

Step 4. In the body of the query, highlight the Example 1 query and click the Execute button (or Press the F5 key).

Step 5. Based on the results of this query, complete the sentences or answer the posed questions.

Step 6. Repeat Steps 4 and 5 for the rest of the queries.