Which two options can be specified in order to access a system-period temporal table for a specific point in time guaranteeing accurate results?
A. A period-specification placed in the FROM clause of a subselect.
B. A period-specification placed in the WHERE clause of a subselect
C. A SELECT statement predicate against the transaction start ID of the base table.
D. A predicate against the start and end columns of the base table placed in the WHERE clause of a subselect. E. A SET of the CURRENT TEMPORAL SYSTEM_TIME special register to a non-null value prior to a SELECT against the temporal table.
Which two options can be specified in order to access a system-period temporal table for a specific point in time guaran
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Which two options can be specified in order to access a system-period temporal table for a specific point in time guaran
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!