SQL Server:为第1列中的每个唯一值插入新行

-- 假设SourceTable结构如下：
-- CREATE TABLE SourceTable (
--     Column1 INT,
--     Column2 VARCHAR(100),
--     Column3 DATETIME
-- );

-- 假设TargetTable结构如下：
-- CREATE TABLE TargetTable (
--     NewColumn1 INT,
--     -- 其他需要的列
-- );

-- 插入SourceTable中Column1的每个唯一值到TargetTable的新行
INSERT INTO TargetTable (NewColumn1)
SELECT DISTINCT Column1
FROM SourceTable;

-- 使用NOT EXISTS避免插入重复值
INSERT INTO TargetTable (NewColumn1)
SELECT DISTINCT Column1
FROM SourceTable s
WHERE NOT EXISTS (SELECT 1 FROM TargetTable t WHERE t.NewColumn1 = s.Column1);

MERGE TargetTable AS target
USING (SELECT DISTINCT Column1 FROM SourceTable) AS source
ON target.NewColumn1 = source.Column1
WHEN NOT MATCHED THEN
    INSERT (NewColumn1)
    VALUES (source.Column1);