语法如下:
go
BULK INSERT Tb4
FROM 'C:\1.txt '
WITH
(
FIELDTERMINATOR = ' |', --以“|”为行内部间隔
ROWTERMINATOR = '\n ', --以回车为一行结束
FIRE_TRIGGERS
)
go
语法如下:
go
BULK INSERT Tb4
FROM 'C:\1.txt '
WITH
(
FIELDTERMINATOR = ' |', --以“|”为行内部间隔
ROWTERMINATOR = '\n ', --以回车为一行结束
FIRE_TRIGGERS
)
go