SQL Server 2019

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

create table fio (first nvarchar (20), middle nvarchar (20), last nvarchar (20));
create table fio2 (fio nvarchar(60));

CREATE TRIGGER fio_tg ON fio
AFTER INSERT
as
insert into fio2 (fio)
select first+' '+middle+' '+last
from inserted;
insert into fio values ('first', 'middle', 'last');
select * from fio;
select * from fio2;


first
middle
last


first
middle
last




fio


first middle last