＋设为首页 ＋添加到收藏夹
各位高手：
我有个问题，在使用bulk insert的时候在from子句部分需要输入数据文件的整个路径，我现在想实现路径名固定，但是文件名不固定，可以任意变化，我试过：
declare @file as char(30)
set @file = aaa
bulk insert rawdata from d:\ + @file + .txt
with (
fieldterminator = \t ,
firstrow = 2,
rowterminator = \n
)
但是报错，高手有没有什么好的方法，救急啊！！
--用动态SQL呢？
--try
declare @s as varchar(8000)
set @s=
set @s=@s+declare @file as char(30) set @file = d:\aa.txt
set @s=@s+bulk insert rawdata from +@file+
set @s=@s+with ( fieldterminator = \t, firstrow = 2, rowterminator =\n )
exec(@s)
declare @file as varchar(30)
set @file = aaa
declare @sql varchar(1000)
set @sql= bulk insert A from c:\ + @file + .txt+
with (+
fieldterminator = \t ,+
firstrow = 1,+
rowterminator = \n+
)
--print @sql
exec(@sql)
