XML

• Topics

  Started by

  Posts

  Last post

• Has anyone here used PowerShell to query SQL Query Plan XML ?

  Has anyone here used PowerShell to query SQL Query Plan XML ? For example, I'm trying to use the Se…

  Eric M Russell

  2 replies

  1 year, 9 months ago

  By: Eric M Russell

• XML Query to return xml element as column for specific attribute value

  Despite having read several articles/examples, I can't solve what seems like it should be a simple …

  ratbak

  2 replies

  2 years, 7 months ago

  By: ratbak

• Parsing a lange XML data-column from one server to another

  Dear PS-scripters. As a newbee I encouter the next challange.... I have a PS script that needs to c…

  gkramer 23701

  16 replies

  2 years, 8 months ago

  By: Ed B

• How to export SQL database tables into multiple XML Files?

  Hi everyone, So I have a database with 10-12 tables with lots of rows (in millions). I have a Indiv…

  Jobs90312

  1 replies

  2 years, 9 months ago

  By: Jobs90312

• Looking for my "why use xml" aha moment

  I'm learning xml. I'm getting the hang of the nitty gritty, tags, elements, etc. I haven't come acr…

  markel

  11 replies

  2 years, 9 months ago

  By: ZZartin

• Split xml into several tables with xslt

  I have a query the creates the XML below. I am trying to format the output with xslt into a email w…

  wburke 85918

  2 replies

  3 years, 2 months ago

  By: wburke 85918

• MSXML2.XMLHTTP

  Using sp_OACreate(MSXML2.XMLHTTP) Object creates. Open("POST"....) works. Send() never returns …

  brucehechler-976230

  4 replies

  3 years, 7 months ago

  By: Sandeep Kataria

• Error in xml schema.

  Hi, I am writting code in xml schema and I am getting this error: The 'http://www.w3.org/2001/XMLSc…

  Username_1999

  1 replies

  3 years, 9 months ago

  By: Username_1999

• Confusion with XML

  I really have not worked a lot with XML and I've only learned of CROSS APPLY in the last couple wee…

  Ext12

  1 replies

  4 years, 3 months ago

  By: ratbak

• How to get at value?

  Hello, I want to pluck out the values for "<rd:DbType>" and "<rd:IsMultiValued>" but co…

  beth-447786

  16 replies

  4 years, 10 months ago

  By: Mr. Brian Gale

• Xquery help please (XML into SQL table)

  Hi everyone, any help with the below would be appreciated - see sample data and desired format belo…

  Mr. Holio

  2 replies

  5 years, 3 months ago

  By: Mark Cowne

• XML Help.. adding a root to the root?

  I have a XML output that gets output into a file for BizTalk to send to another company, and I'm tr…

  oogibah

  1 replies

  5 years, 4 months ago

  By: oogibah

• Creating XML in SQL using namespaces

  Hello everyone, Please help! I have a sql statement that creates the following output <rsm:Cross…

  XMLuser007

  1 replies

  5 years, 7 months ago

  By: XMLuser007

• Is there a way to walk "up" from current XML node

  Hello, I’m attempting to get some information from SSRS RDL’s.  Is there a way to back up from…

  beth-447786

  3 replies

  5 years, 11 months ago

  By: DesNorton

• Populate an existing XML file with SQL data

  Hi, is it possible to populate an existing XML file with SQL data?  If so, how?  The…

  TJ_T

  2 replies

  6 years ago

  By: Eirikur Eiriksson