Home Forums Programming XML How to filter the namespace from the xml in SQLServer..plz help RE: How to filter the namespace from the xml in SQLServer..plz help

  • Actually what i am doing is my query is fetching xml from db which contains the name space

    like

    <XML xmmlns:https://temp.../test.xsd>

    Declare @xml xml

    select @xml =xmlcontent from tablename where id =4

    this @xml looks like

    <XML xmmlns:https://temp.../test.xsd>

    <>

    <>

    .....

    i want to remove the namespace 'xmmlns:https://temp.../test.xsd'

    plz suggest me the query how to use

    'WITH XMLNAMESPACES(DEFAULT 'http://somenamespace')'

    in this sql