SQL Server 读取CSV中的数据

测试:

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

上一篇:只会java,参加acm如何?


下一篇:linuxDNS