The INSERT statement adds one or more new rows to a database table. The format of the INSERT statement is:
insert-statement ::=
INSERT INTO table-name
[ ( column {, column } ) ]
insert-source
insert-source ::=
DEFAULT VALUES |
table-value-constructor |
query-expression
In Fernhill SCADA, the INSERT Statement can only be used to insert rows into a Database Table Tag.
The table-name must be qualified by the schema name DatabaseTable.
INSERT INTO DatabaseTable.BatchResults DEFAULT VALUES
INSERT INTO DatabaseTable.TagSnapshot (EventTime, Flow, Level) VALUES (CURRENT_TIMESTAMP, 12.7, 1.2 )
The CURRENT_TIMESTAMP Function returns the current date and time.
INSERT INTO DatabaseTable.AlarmCounts (AlarmState, AlarmCount) SELECT StateAsText, COUNT(*) FROM AlarmEvent.Alarms GROUP BY StateAsText
Fernhill SCADA .NET Framework Data Provider
To learn about the .NET Framework Data Provider for Fernhill SCADA (FernhillSoftware.Data.FernhillScadaClient).
To learn about the ODBC driver in Fernhill SCADA.
To learn about the SQL Test Tool.
For the meaning of terms used in Fernhill SCADA.