SQL Server 2008 : BULK INSERT csv - is it possible to choose fields?

Question

我正在做:

BULK INSERT CSVTest FROM 'c:\csvtest.txt'
WITH
(FIELDTERMINATOR = ',',
 ROWTERMINATOR = '\n')
GO

--Check the content of the table.
SELECT *
FROM CSVTest
GO

--Drop the table to clean up database.
SELECT *
FROM CSVTest
GO

是否可以仅插入 csv 中的特定字段？

Answer 1

或者，您可以bulk insert into a view .

另请参阅this question .