T-SQL Script: Generate INSERT statements from existing data

SELECT 
    'INSERT INTO ' + t.name + ' (' +
    STRING_AGG(c.name, ', ') + ') VALUES (' +
    STRING_AGG(QUOTENAME(CONVERT(NVARCHAR(MAX), d.value), ''''), ', ') + ');'
FROM sys.tables t
JOIN sys.columns c ON t.object_id = c.object_id
CROSS APPLY (
    SELECT COLUMN_NAME = c.name,
           value = (SELECT TOP 1 v = COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS)
) d
GROUP BY t.name;