Insert latest revision data

The AVEVA Historian supports inserting the first (original) and last (latest) version of a tag value.

You insert revision data into history by specifying LATEST for the value of the wwVersion parameter in a Transact-SQL INSERT statement. This is essentially the same as performing an update, but without some of the limitations.

You can insert revision data for both I/O Server tags and non-I/O Server tags.

The following query inserts revision data for 'NonIOTag1' into history:

INSERT INSQL.Runtime.dbo.AnalogHistory (DateTime, TagName, Value, OPCQuality, wwVersion)

VALUES('2002-11-11 16:05:10', 'NonIOTag1', 15, 192, 'LATEST')