Explicitly defining namespace in For XML query

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » Explicitly defining namespace in For XML...

Explicitly defining namespace in For XML query

Rate Topic

Display Mode

Topic Options

Author

Message

dmaslowski

Posted Monday, February 04, 2013 12:30 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 8:29 AM
Points: 2, Visits: 24

I need to mimic the Namespace of a legacy app exactly.
It should look like this:
<Customers xmlns="x-schema:D:\APPS\Customer.xdr">
</Customers>

When I put in my query With Namespace
WITH XMLNAMESPACES ('x-schema:D:\APPS\Customer.xdr' as ns)
I get:
<Customers xmlns:ns="x-schema:D:\APPS\Customer.xdr">

When I try to not specify 'as ns' I get an error.

How can I match this exactly?
<Customers xmlns="x-schema:D:\APPS\Customer.xdr">

Thanks!

Post #1415458

opc.three

Posted Tuesday, February 05, 2013 6:16 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:57 PM
Points: 6,724, Visits: 11,771

Try it like this:

WITH XMLNAMESPACES (DEFAULT 'x-schema:D:\APPS\Customer.xdr')

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1415787

« Prev Topic | Next Topic »

Permissions