Add new rows to temporal tables.
There is no special temporal syntax for inserting rows into temporal tables. Use the standard SQL INSERT statement. However, note the following:
- You must include values for the beginning and ending bound columns that constitute the valid-time derived period column.
- As for any type of derived period column in the database, you cannot insert Period type values for the derived period column itself.