SQL Server 2017

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

create table Dependencies (
	id int primary key identity,
	isResolved int
);

create table DependencyList (
	id int primary key identity,
	DependencyId int
);
CREATE TRIGGER myTrigger ON Dependencies FOR INSERT
AS INSERT INTO DependencyList (DependencyId) SELECT Id FROM inserted;
insert into Dependencies(isResolved) values (0);
2 rows affected

insert into Dependencies(isResolved) values (1);
2 rows affected

select * from Dependencies


id
isResolved


1
0

2
1


select * from DependencyList


id
DependencyId


1
1

2
2