Forum Discussion
Dan-ketil
Mar 26, 2020Copper Contributor
Using variables in select and xml files
Hi
I have created a t-sql that read an xml file and store it into ms sql 2016 database.
DECLARE
@x xml,
@@XML_Location VARCHAR(255) = 'FROM OPENROWSET (BULK ''''\\xmlsrv\proxml\'
@XML_File VARCHAR(255) = 'GEN.xml',
;
SELECT @x = P
--FROM OPENROWSET (BULK '\\xmlsrv\proxml\GEN.xml', SINGLE_BLOB) AS Element(P)
@XML_Location & @XML_File, SINGLE_BLOB) AS Element(P)
.......
....
The script works if i use the from statement directly, but if I try to use declared variables it fails with message:
Msg 102, Level 15, State 1, Line 16
Incorrect syntax near '@XML_Location '.
What am I doing wrong?
BR
Dan-Ketil
No RepliesBe the first to reply