Hi, I need to insert a XML file into table.

• sharleegarcia

  Newbie

  Points: 5

  More actions

  February 6, 2014 at 9:41 am

  #282021

  Hi, I need to insert a XML file into table using SQL server 2008.

  The issue is that when i try to insert the xml file some file didn't insert into table. The file were the bigger(more than 110 kb).

  I use this code to insert the files.

  INSERT INTO T(XmlCol)

  SELECT * FROM OPENROWSET(

  BULK 'c:\SampleFolder\SampleData3.txt',

  SINGLE_BLOB) AS x;

  Please if somebody can help me let me know.

  Thanks