我想将某个文件中的内容导入到数据表中,文件的目录是动态的,我应该怎么写?
BULK INSERT report_acc FROM 'd:\work\report\'+ @filename
WITH (
FIELDTERMINATOR = '|',
ROWTERMINATOR = '-'
)@filename应该是 20081027\20081027.txt
BULK INSERT report_acc FROM 'd:\work\report\'+ @filename
WITH (
FIELDTERMINATOR = '|',
ROWTERMINATOR = '-'
)@filename应该是 20081027\20081027.txt
set @filename='d:\work\report\'
exec('BULK INSERT report_acc FROM '''+@filename+'''
WITH (
FIELDTERMINATOR = ''|'',
ROWTERMINATOR = ''-''
)')
bulk insert 是不是不能导入这种格式“8100-8112”