SQL Server 读取CSV中的数据

测试：

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

转载于:https://www.cnblogs.com/chenyongblog/p/4379283.html