Select Item
This item type is an SQL Item for querying the SQL database using select statements.
Parameters of the item type:
| Name | Description | ID | Flags |
|---|---|---|---|
| Select statement | Select statement for querying the SQL server | 18653 | Persisted, Multiline |
The select statement is a parameterized string containing the query, and with the paramaters as specified on the following format:
@[myparam]:[param datatype]
An example of this could be
select * from my_table
where my_int_column = @a:int
In OPC UA this would expose an object with a First method that takes the max number of rows and a parameter @a that must be of type int.
Supported datatypes:
- int
- float
- datetime
- nvarchar