Explicitly defining namespace in For XML query

• dmaslowski

  SSC Veteran

  Points: 230

  More actions

  February 4, 2013 at 12:30 pm

  #394097

  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!

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  February 5, 2013 at 6:16 am

  #1584341

  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