csv内容:
a;1;Y005585
b;2;Y005586
c;3;Y005587
创建测试表:
create table Test
(
Name nvarchar(10),
Age int,
T nvarchar(10)
)
插入语句:
Bulk insert dbo.Test
From 'E:\mysql\aa.csv'
with(
fieldterminator = ';',
--FirstRow =1,
rowterminator = '\n'