BULK INSERT dbo.SysReference
FROM 'E:\testbulk.txt'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = ';'
)
FIELDTERMINATOR ——字段分割
ROWTERMINATOR——行分割
txt文档格式
CS_OrderDA,15,12,204,null,CP_00010,206,DXDZ190816001,5,5;
BULK INSERT dbo.SysReference
FROM 'E:\testbulk.txt'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = ';'
)
FIELDTERMINATOR ——字段分割
ROWTERMINATOR——行分割
txt文档格式
CS_OrderDA,15,12,204,null,CP_00010,206,DXDZ190816001,5,5;