SQL in InfoAsset Manager

Technical Note

June 2010

The following topics provide information about using SQL in InfoAsset Manager. These topics do not have to be read in the order they are listed in, although, if you are unfamiliar with SQL, you may find it useful to do so.

Basic Object Selection

Advanced Topics in Selection

Deletion

Insertion

Assignment

Functions

Control Logic

Variables

Other Variables

Array Fields

One-To-Many Links

Explicit Select Clauses and Group By Clauses

Order By Clauses

Prompts

Time Series Results

Scenarios

Time Series Data

Error Messages