SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table tab1 (id bigint identity(1,1), col_1 varchar(4))
create table tab2 (id bigint identity(1,1), col_1 varchar(4), id_tab1 bigint)
create table tab3 (id bigint identity(1,1), col_1 varchar(4), id_tab2 bigint)
create table tab4 (id bigint identity(1,1), col_1 varchar(4), id_tab3 bigint)
insert into tab1 (col_1)
output inserted.col_1, inserted.id 
into tab2 (col_1, id_tab1)
values ('AAAA'),('BBBB'),('CCCC')
insert into tab3 (col_1, id_tab2)
output inserted.col_1, inserted.id 
into tab4 (col_1, id_tab3)
select col_1, id from tab2
6 rows affected

select * from tab1;


id
col_1


1
AAAA

2
BBBB

3
CCCC


select * from tab2;


id
col_1
id_tab1


1
AAAA
1

2
BBBB
2

3
CCCC
3


select * from tab3;


id
col_1
id_tab2


1
AAAA
1

2
BBBB
2

3
CCCC
3


select * from tab4;


id
col_1
id_tab3


1
AAAA
1

2
BBBB
2

3
CCCC
3