Solved

prevent XML namespace declarations from being added to every FOR XML section

Posted on 2009-05-07
1
322 Views
Last Modified: 2013-11-08
I am using FOR XML in Microsoft SQL Server 2005 to generate XML from SQL.  I am using the PATH mode and the WITH XMLNAMESPACES clause.  The problem is that the XML namespace declarations are being added to every FOR XML section.  It does specify in this MSDN technical article that it will do that. http://msdn.microsoft.com/en-us/library/ms345137(SQL.90).aspx  I have pasted their example of what happens below.  See each <o:Order> line has the namespace declaration repeated.  I need to prevent this though in order for my XML file to be valid.  I only want this at the top element.  Any suggestions would be greatly appreciated.
Thank you,
Aana
<doc xmlns:o="urn:example.com/order" xmlns:c="urn:example.com/customer" 

     xmlns="urn:example.com/doc">

  <c:Customer ID="ALFKI">

    <c:Orders>

      <o:Order xmlns:o="urn:example.com/order"

         xmlns:c="urn:example.com/customer" xmlns="urn:example.com/doc" 

         OrderID="10643" />

      <o:Order xmlns:o="urn:example.com/order" 

         xmlns:c="urn:example.com/customer" xmlns="urn:example.com/doc" 

         OrderID="10692" />

      <o:Order xmlns:o="urn:example.com/order" 

         xmlns:c="urn:example.com/customer" xmlns="urn:example.com/doc" 

         OrderID="10702" />

      <o:Order xmlns:o="urn:example.com/order" 

         xmlns:c="urn:example.com/customer" xmlns="urn:example.com/doc" 

         OrderID="10835" />

      <o:Order xmlns:o="urn:example.com/order" 

         xmlns:c="urn:example.com/customer" xmlns="urn:example.com/doc" 

         OrderID="10952" />

      <o:Order xmlns:o="urn:example.com/order" 

         xmlns:c="urn:example.com/customer" xmlns="urn:example.com/doc" 

         OrderID="11011" />

    </c:Orders>

    <c:CompanyName>Alfreds Futterkiste</c:CompanyName>

    <c:ContactName 

       ContactTitle="Sales Representative">Maria Anders</c:ContactName>

    <c:Address ZIP="12209">

      <c:Street>Obere Str. 57</c:Street>

      <c:City>Berlin</c:City>

    </c:Address>

  </c:Customer>

Open in new window

0
Comment
Question by:anixon93
1 Comment
 

Accepted Solution

by:
anixon93 earned 0 total points
ID: 24328304
Well, I figured how to get around this for my purposes.  Basically not including the namespaces in the SQL query and adding them later after my C# code processes the XML template.  
Thanks
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I found this questions asking how to do this in many different forums, so I will describe here how to implement a solution using PHP and AJAX. The logical flow for the problem should be: Write an event handler for the first drop down box to get …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now