XML

• Topics

  Started by

  Posts

  Last post

• For XML question

  I am trying put some structure around my XML and running into an issue.  I would like <Firs…

  TJ_T

  2 replies

  6 years ago

  By: TJ_T

• Importing an XML file into a sql table

  Edit to make things more understandable, I wish to import my XML file into an sql table. The XML&nb…

  dallibabs

  12 replies

  6 years, 1 month ago

  By: Solomon Rutzky

• Problem reading all Attributes into SQL table

  Hello everyone.  I'm writing a proc that imports several XML files and stores them in a SQL ta…

  md44

  35 replies

  6 years, 2 months ago

  By: mfconners

• Get all Attributes from this XML

  Hi, how can i get a Resultlist (see below) from this XML?------------------------------------------…

  info 58414

  8 replies

  6 years, 3 months ago

  By: drew.allen

• SQL For XML Array with Header and Multiple Detail

  How do I get the following output XML using SQL?<Base> <Header>  <HdrAttrib1&g…

  sadie

  1 replies

  6 years, 3 months ago

  By: Scott Coleman

• SQLXMLBulkLoad Error

  Dear All, I am new on using SQLXML Bulk Load object to import XML to SQL server for further checkin…

  sariel.wong

  2 replies

  6 years, 3 months ago

  By: sariel.wong

• How to split comma separated values stored in XML node Without using function- SQL Server 2012

  I have a requirement to split a csv data inside a xml node column. I am using SQL server 2012. I wa…

  Patchai001

  5 replies

  6 years, 3 months ago

  By: Jeff Moden

• Odd results reading attributes when schema applied

  I was working on adding a schema to some XML and found that it would suddenly break some queries th…

  andycadley

  3 replies

  6 years, 7 months ago

  By: andycadley

• 1gb XML into SQL using xPath or XQuery

  Hi, I'm new to SQL and I have been trying to learn how to read my 1gb XML into SQL using xPath. I h…

  luke 24660

  4 replies

  6 years, 11 months ago

  By: Eirikur Eiriksson

• Parse an XML value with a colon in SQL Server

  I need help to parse XML in SQL Server. I need to get "d1p1:Val2" value and concatenation of values…

  duhast2012

  2 replies

  6 years, 12 months ago

  By: duhast2012

• Cross apply / XML shredding -- mutiple nodes creating problems

  Oh XML Gurus please help. I don't have a clear understanding of CROSS APPLY.  I have the foll…

  jmetape

  3 replies

  7 years, 1 month ago

  By: Scott Coleman

• Selecting item from xml where multiples can exist.

  I have some xml which looks like this:<cBusinessAppraisal FilePath="_Training_NPV TEST\PROVAL TE…

  gzt4gs

  3 replies

  7 years, 1 month ago

  By: drew.allen

• Please help me out on this facing the xml error while running job

  FOR XML could not serialize the data for node because it contains a character (0x0000) which is no…

  kulasekhar090

  2 replies

  7 years, 2 months ago

  By: HappyGeek

• Importing XML in SQL Table

  I am trying to import this XML in a SQL table but keeps on getting NULL. Here's my code. Did I miss…

  jennette_alambra

  4 replies

  7 years, 3 months ago

  By: Eirikur Eiriksson

• Importing Unicode XML Code SQL

  I am trying to import XML data from the following webpage: http://www.tcmb.gov.tr/kurlar/today…

  tibetors

  1 replies

  7 years, 5 months ago

  By: Eirikur Eiriksson