I’m having a few issues when inserting data from a XML file to a SQL Server database. How can I get the file name dynamically? This file is put on that path with a different number every time but always starts with Idoc and it’s a .xml file. I’m having troubles setting a variable inside OPENROWSET. At the moment I’m
Tag: openrowset
SQL Server – OPENROWSET Server name error using parameters
I’m having trouble with this query…Any idea how to declare variables and make it visible to OPENROWSET query? DECLARE @SERVERNM VARCHAR; SET @SERVERNM = (SELECT(CAST(CONNECTIONPROPERTY(‘…