更新时间:2023-01-21 22:43:56
我将创建一个临时表,批量插入很多,在新表中选择所需的内容,然后将其删除.
I'd create a temporary table, bulk insert the lot, select into the new table what you need and drop the temporary table.
类似
CREATE TABLE dbo.TempImport
(
FirstName varchar(255),
LastName varchar(255),
Country varchar(255),
Age varchar(255)
)
GO
BULK INSERT dbo.TempImport FROM 'PathToMyTextFile' WITH (FIELDTERMINATOR = ';', ROWTERMINATOR = '\n')
GO
INSERT INTO dbo.ExistingTable
(
FName,
LName,
Country
)
SELECT FirstName,
LastName,
Country
FROM dbo.TempImport
GO
DROP TABLE dbo.TempImport
GO