I need some help in understanding the way temporal tables work.
1: If there is a row existing and tomorrow new information comes in for the same row would temporal table automatically adjust dates for earlier record if I am just inserting new row or does it neccessarily have to be an update.
In case insert works ,does the table need to have primary key based on which update would happen ?
2: Although ValidTime and TransactionTime are used for different purpose,It seems we can always replace transactiontime with validtime and still get all functionality
3: Temporal table should obviously alwys have incremental approach .