SELECT @XML_FILE = (
SELECT CONVERT(xml,T.c)
FROM OPENROWSET(BULK 'D:\JXC\App_Data\C000000001.xml ',SINGLE_BLOB) T(c))
'D:\JXC\App_Data\C000000001.xml
是一个可变的文件,如何读取啊,希望高人回答
------解决方案--------------------
不知道这样行不?
declare @File nvarchar(20)
set @File= 'D:\JXC\App_Data\C000000001.xml '
declare @sql nvarchar(4000)
set @sql= 'SELECT @XML_FILE=CONVERT(xml,T.c)
FROM OPENROWSET(BULK ' ' '[email protected]+ ' ' ',SINGLE_BLOB) T(c) '
exec(@sql)
------解决方案--------------------
declare @File nvarchar(20)
set @File= 'D:\JXC\App_Data\C000000001.xml '
declare @sql nvarchar(4000)
declare @retv varchar(2000)
set @sql= 'SELECT @XML_FILE=CONVERT(xml,T.c)
FROM OPENROWSET(BULK ' ' '[email protected]+ ' ' ',SINGLE_BLOB) T(c) '
exec sp_executesql @sql,N ' @retv varchar(2000) out ',@retv out
用 sp_executesql