测试:
Script:
create table #Test
(
Name nvarchar(10),
Age int,
T nvarchar(10)
) BULK INSERT #Test
From 'I:\AAA.csv'
with(
fieldterminator = ',',
rowterminator = '\n'
) select * from #Test drop table #Test
Result:
Name Age T
TestA 13 Aug
TestB 14 App
TestC 15 Jus