我有一堆文件要导入到SQL Server数据库中-在目录是变量的情况下,如何实现类似于以下内容:
DECLARE @Directory VARCHAR(256)
SET @Directory = 'C:\some\directory\name\'
INSERT INTO dbo.MyTable
SELECT * FROM OPENROWSET(
BULK @Directory + 'importfile.txt',
FORMATFILE = @Directory +'importfileFormatFile.Xml'
) AS t1;
这是你想要的吗?
DECLARE @Directory VARCHAR(256);
SET @Directory = 'C:\some\directory\name\';
DECLARE @sql NVARCHAR(MAX);
SET @sql = '
INSERT INTO dbo.MyTable
SELECT *
FROM OPENROWSET(BULK ''' + @Directory + 'importfile.txt'',
FORMATFILE = '''+@Directory +'importfileFormatFile.Xml''
) AS t1
';
exec sp_executesql @sql;
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句