XML namespace

• pavan3027

  Newbie

  Points: 1

  More actions

  June 20, 2008 at 12:35 pm

  #71444

  hi

  help needed in regard to xml namespace

  while I'm able to make the following work

  With XMLNAMESPACES ('http://www.test.namespace.com/ns/1.0' as c)

  Select 'value' [c:test] For xml path(''),Elements, type

  I have a problem with the following

  Declare @x xml;

  With XMLNAMESPACES ('http://www.test.namespace.com/ns/1.0' as c)

  SET @x = Select 'value' [c:test] For xml path(''),Elements, type

  Select @x

  Thanks

  Pavan

• Adrian Nichols-360275

  SSCertifiable

  Points: 7694

  More actions

  June 23, 2008 at 8:39 am

  #832745

  I think something like this should work.....

  Declare @x xml;

  With XMLNAMESPACES ('http://www.test.namespace.com/ns/1.0' as c)

  SELECT @x = 'value' [c:test] For xml path(''),Elements, type

  Select @x

  ---

  
  Ade

  A Freudian Slip is when you say one thing and mean your mother.
  For detail-enriched answers, ask detail-enriched questions...[/url]

• peterhe

  SSChampion

  Points: 11469

  More actions

  June 24, 2008 at 1:41 pm

  #833570

  This works:

  Declare @x xml;

  With XMLNAMESPACES ('http://www.test.namespace.com/ns/1.0' as c)

  SELECT @x = (SELECT 'value' [c:test] For xml path(''),Elements, type)

  Select @x