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