SQL Server 2019

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

create table Musteriler (MusteriId int identity not null primary key, 
   Ad nvarchar(100) not null,
   TCNo char(10) not null);
   
create table Detaylar (DetayId int identity not null primary key, 
   MusteriId int not null foreign key references Musteriler(MusteriID),
   BaslangicTarihi DateTime not null default getdate() );
   
CREATE TRIGGER [trgMusteriInsert]
	ON [dbo].[Musteriler] -- Detaylarda bir trigger'a anlam veremiyorum
    AFTER INSERT
    AS
    BEGIN
        insert into Detaylar (MusteriId)
        SELECT musteriId 
        FROM inserted; 
    END   
insert into Musteriler (Ad, TCNo) values
(N'Ali', '1234567890'),
(N'Veli', '1234567891'),
(N'Kirkdokuz', '1234567892'),
(N'Elli', '1234567893');

Select * from Musteriler;
Select * from Detaylar;


MusteriId
Ad
TCNo


1
Ali
1234567890

2
Veli
1234567891

3
Kirkdokuz
1234567892

4
Elli
1234567893




DetayId
MusteriId
BaslangicTarihi


1
4
2020-10-20 14:30:56.530

2
3
2020-10-20 14:30:56.530

3
2
2020-10-20 14:30:56.530

4
1
2020-10-20 14:30:56.530

MusteriId	Ad	TCNo
1	Ali	1234567890
2	Veli	1234567891
3	Kirkdokuz	1234567892
4	Elli	1234567893

DetayId	MusteriId	BaslangicTarihi
1	4	2020-10-20 14:30:56.530
2	3	2020-10-20 14:30:56.530
3	2	2020-10-20 14:30:56.530
4	1	2020-10-20 14:30:56.530