Insert or update data with transact-SQL statements

Using the Transact-SQL INSERT and UPDATE statements, you can insert or update data in the AnalogHistory, DiscreteHistory, StringHistory, and History tables (Value and OPCQuality only).

The AVEVA Historian uses the same security defined for SQL Server for inserting and updating data. However, as with a CSV file, you cannot delete any data value from storage.

If you are attempting to insert or update values whose time period spans across missing history blocks, the necessary history block(s) are recreated for the duration of the data.

For guidelines on using this import method versus other import methods, see Guidelines for importing, inserting, and updating history data.