SQL Server 2017

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

CREATE TABLE customers (cus_id INT IDENTITY(1,1) PRIMARY KEY,
                        name VARCHAR(255));
CREATE TABLE payments (pay_id INT IDENTITY(1,1) PRIMARY KEY,
                       cus_id INT,
                       amount INT,
                       FOREIGN KEY (cus_id) REFERENCES customers (cus_id));
CREATE TRIGGER tr
ON customers
AFTER INSERT
AS
WITH cte AS ( SELECT 1 num 
              UNION ALL
              SELECT num + 1 FROM cte WHERE num < 2 )
INSERT INTO payments (cus_id, amount)
SELECT INSERTED.cus_id, RAND(CHECKSUM(NEWID())) * 1000
FROM INSERTED
CROSS JOIN cte;
WITH cte AS ( SELECT 1 num 
              UNION ALL
              SELECT num + 1 FROM cte WHERE num < 5 )
INSERT INTO customers (name)
SELECT CONVERT(VARCHAR(255), NEWID())
FROM cte;
15 rows affected

DROP TRIGGER tr;
SELECT * FROM customers;
SELECT * FROM payments;


cus_id
name


1
949BEFA4-1F81-4B28-90BB-B1F2637F3230

2
D680817A-5257-4499-9096-14C7AA33370A

3
39738363-C779-4D87-8145-D35B14D53684

4
5B341873-7769-48CB-BD3B-F6FD92D4BB99

5
C1B114CC-92ED-4A5D-A538-E2060BFA1E0D




pay_id
cus_id
amount


1
5
870

2
4
89

3
3
851

4
2
981

5
1
688

6
5
964

7
4
437

8
3
747

9
2
32

10
1
685

cus_id	name
1	949BEFA4-1F81-4B28-90BB-B1F2637F3230
2	D680817A-5257-4499-9096-14C7AA33370A
3	39738363-C779-4D87-8145-D35B14D53684
4	5B341873-7769-48CB-BD3B-F6FD92D4BB99
5	C1B114CC-92ED-4A5D-A538-E2060BFA1E0D