clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2335751 fiddles created (27468 in the last week).

create table raw_data ( id int identity not null primary key clustered, value float not null, start_ts datetime2(3) generated always as row start hidden not null, end_ts datetime2(3) generated always as row end hidden not null default dateadd(d,5,sysutcdatetime()), period for system_time(start_ts,end_ts) ) with (system_versioning = on ( history_table = dbo.raw_data_hist, data_consistency_check =on ) );
 hidden batch(es)


insert into raw_data(value) output inserted.end_ts select 5
end_ts
9999-12-31 23:59:59.999
 hidden batch(es)