clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3798770 fiddles created (41858 in the last week).

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


CREATE TRIGGER fio_tg ON fio AFTER INSERT as insert into fio2 (fio) select first+' '+middle+' '+last from inserted;
 hidden batch(es)


insert into fio values ('first', 'middle', 'last'); select * from fio; select * from fio2;
first middle last
first middle last
fio
first middle last
 hidden batch(es)