SQL Server 2019

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

create table A(id int, val int, PRIMARY KEY (ID));
create table B(logdate datetime, log varchar(100), id int, val int);
create trigger trg_A_Ins on A for insert as
begin
  insert into B
  select getdate(), 'insert A', id, val from inserted;
end;
create trigger trg_A_Upd on A for update as
begin
  insert into B
  select getdate(), 'update A', id, val from inserted;
end;
insert into A values(1,10);
insert into A values(2,20);
insert into A values(3,30);
insert into A values(4,40);

select * from A;
update A set id=id+100 where val<20;
select * from A;
select * from B;


id
val


1
10

2
20

3
30

4
40




id
val


2
20

3
30

4
40

101
10




logdate
log
id
val


2020-12-04 21:27:17.047
insert A
1
10

2020-12-04 21:27:17.047
insert A
2
20

2020-12-04 21:27:17.047
insert A
3
30

2020-12-04 21:27:17.047
insert A
4
40

2020-12-04 21:27:17.047
update A
101
10

logdate	log	id	val
2020-12-04 21:27:17.047	insert A	1	10
2020-12-04 21:27:17.047	insert A	2	20
2020-12-04 21:27:17.047	insert A	3	30
2020-12-04 21:27:17.047	insert A	4	40
2020-12-04 21:27:17.047	update A	101	10