关于BULK变量的问题
- SQL code
BULK INSERT #TMP1FROM 'D:\盘点单\BM20120815SBK.txt' WITH ( FIELDTERMINATOR =',', ROWTERMINATOR ='\n', KILOBYTES_PER_BATCH=5000 )
如果我的文件名是写死的没有问题
如果换成变量该怎么处理呢
- SQL code
DECLARE @fileName NVARCHAR(50)SET @fileName='D:\盘点单\BM20120815SBK.txt' BULK INSERT #TMP1FROM 'D:\盘点单\BM20120815SBK.txt' WITH ( FIELDTERMINATOR =',', ROWTERMINATOR ='\n', KILOBYTES_PER_BATCH=5000 )
[解决办法]
- SQL code
--这种只能用动态sqlDECLARE @fileName NVARCHAR(50),@sql nvarchar(1000)SET @fileName='D:\盘点单\BM20120815SBK.txt' select @sql='BULK INSERT #TMP1FROM '''+@fileName+''' WITH ( FIELDTERMINATOR ='','', ROWTERMINATOR =''\n'', KILOBYTES_PER_BATCH=5000 )'exec(@sql)