Hi,

i think the below script will help you. (this is not my script)

CREATE TABLE XmlImportTest

(

xmlFileName VARCHAR(300),

xml_data xml

)

GO

DECLARE @xmlFileName VARCHAR(300)

SELECT @xmlFileName...