SQL Server 2019

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

create table t (id int identity, status varchar(100));
create table audit(id int, old_status varchar(100), new_status varchar(100), updated_at datetime);
create trigger StatusUpdate
on t
After UPDATE as

if exists(select * from inserted i 
          inner join deleted d on d.id = i.id
          where d.status != 'Executed' 
          and i.status = 'Executed')
begin
insert into audit (id, old_status, new_status, updated_at)
select i.id, d.status, i.status, getdate() 
from inserted i 
          inner join deleted d on d.id = i.id
          where d.status != 'Executed' 
          and i.status = 'Executed'
end
insert t (status) select 'Draft';
update t set status = 'Executed' where id = 1;
3 rows affected

select * from audit;


id
old_status
new_status
updated_at


1
Draft
Executed
2024-04-23 16:07:54.397