22,210
社区成员
发帖
与我相关
我的任务
分享
declare @sql as varchar(2000)
set @sql = 'bulk insert temp0129..a from ''D:\boss\d\d.txt'' WITH(FIELDTERMINATOR =''|'',ROWTERMINATOR = '''+char(13)+char(10)+''',FIRE_TRIGGERS)'
exec( @sql)
BULK INSERT 表名
FROM 'C:\name.txt'
WITH
(
FIELDTERMINATOR='|',
ROWTERMINATOR='/n'
);
BULK INSERT temp0129..a
FROM 'D:\boss\d\d.txt '
WITH (
FIELDTERMINATOR = '|',
ROWTERMINATOR = '\n'
)
BULK INSERT 库名..表名
FROM 'c:\test.txt'
WITH (
FIELDTERMINATOR = '|',
ROWTERMINATOR = '\n'
)