InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 12:42:29 GMT20http://www.sqlservercentral.com/Forums/Topic421818-145-1.aspx[img]http://www.rlgf.info/16.jpg[/img][img]http://www.rlgf.info/13.jpg[/img][img]http://www.rlgf.info/14.jpg[/img][img]http://www.rlgf.info/17.jpg[/img][img]http://www.ryzu.info/10.jpg[/img]Thu, 15 Nov 2012 19:39:27 GMTstarshayizhttp://www.sqlservercentral.com/Forums/Topic421818-145-1.aspxHi, i think the below script will help you. (this is not my script)CREATE TABLE XmlImportTest( xmlFileName VARCHAR(300), xml_data xml)GODECLARE @xmlFileName VARCHAR(300)SELECT @xmlFileName = 'c:\TestXml.xml'-- dynamic sql is just so we can use @xmlFileName variable in OPENROWSETEXEC('INSERT INTO XmlImportTest(xmlFileName, xml_data)SELECT ''' + @xmlFileName + ''', xmlData FROM( SELECT * FROM OPENROWSET (BULK ''' + @xmlFileName + ''' , SINGLE_BLOB) AS XMLDATA) AS FileImport (XMLDATA)')GOSELECT * FROM XmlImportTestDROP TABLE XmlImportTestSun, 28 Oct 2012 23:58:48 GMTDestroyerhttp://www.sqlservercentral.com/Forums/Topic421818-145-1.aspxhi well am on fire rite know ,,,,,,:Danyways i am new to sql not as expert as you guys but the thing am stuck here is i need to import a simple .xml file into sql server 2005 in a table where there is already a coloumn of (xml)data type in my table so can you please please give me a correct syntax or a method to do this no links plzz as i wont understand in this situation pleaes help thanksTue, 13 Nov 2007 15:39:03 GMTDreamsz