SQL Server，从 CSV 导入。 “插入只读列“id”失败。”

如何使用 SQL Server 从 CSV 导入数据并处理"插入只读列'id'失败"错误

sql
CREATE TABLE MyTable (
    id INT IDENTITY(1,1) PRIMARY KEY,
    name VARCHAR(50) NOT NULL,
    age INT,
    email VARCHAR(50) READONLY
);

sql
BULK INSERT MyTable
FROM 'C:\path\to\file.csv'
WITH (
    FIELDTERMINATOR = ',',
    ROWTERMINATOR = '\n',
    FIRSTROW = 2
);

sql
INSERT INTO MyTable (name, age)
SELECT name, age
FROM TempTable;

sql
ALTER TABLE MyTable
ALTER COLUMN email VARCHAR(50) NULL;