Changing Element Name

hi,
is there way can change name of element .

for example if have following xml

<applicationdata xmlns="">
<recordid id="d_72bb6d91a3d946debd0f0b58b51ce56c">11</recordid>
</applicationdata>

and want change element name recordid to other value e.g. sequencenumber
can achieved?

---

usm121

declare @xml xml

set @xml='

<applicationdata xmlns="">

<recordid id="d_72bb6d91a3d946debd0f0b58b51ce56c">11</recordid>

<address id="d_49ef04a0b3df4a0eb03bbe57f3a501a7">

<row id="d_49ef04a0b3df4a0eb03bbe57f3a50117">

<city id="d_49ef04a0b3df4a0eb03bbe57f3a50127">a</city>

<city1 id="d_49ef04a0b3df4a0eb03bbe57f3a50137">b</city1>

</row>

<row id="d_49ef04a0b3df4a0eb03bbe57f3a50117">

<city id="d_49ef04a0b3df4a0eb03bbe57f3a50127">aa</city>

<city1 id="d_49ef04a0b3df4a0eb03bbe57f3a50137">bb</city1>

</row>

<row id="d_49ef04a0b3df4a0eb03bbe57f3a50117">

<city id="d_49ef04a0b3df4a0eb03bbe57f3a50127">aaa</city>

<city1 id="d_49ef04a0b3df4a0eb03bbe57f3a50137">bbb</city1>

</row>

</address>

</applicationdata>'

select @xml.query('

<applicationdata xmlns="">

<sequencenumber id="{/applicationdata/recordid/@id}">{data(/applicationdata/recordid)}</sequencenumber>

<address id="d_49ef04a0b3df4a0eb03bbe57f3a501a7">

{

for $row in /applicationdata/address/row

return

<row id="{$row/@id}">

<city id="{$row/city/@id}">{data($row/city)}</city>

<street id="{$row/city1/@id}">{data($row/city1)}</street>

</row>

}

</address>

</applicationdata>

')

--result out

<applicationdata xmlns="">

<sequencenumber id="d_72bb6d91a3d946debd0f0b58b51ce56c">11</sequencenumber>

<address id="d_49ef04a0b3df4a0eb03bbe57f3a501a7">

<row id="d_49ef04a0b3df4a0eb03bbe57f3a50117">

<city id="d_49ef04a0b3df4a0eb03bbe57f3a50127">a</city>

<street id="d_49ef04a0b3df4a0eb03bbe57f3a50137">b</street>

</row>

<row id="d_49ef04a0b3df4a0eb03bbe57f3a50117">

<city id="d_49ef04a0b3df4a0eb03bbe57f3a50127">aa</city>

<street id="d_49ef04a0b3df4a0eb03bbe57f3a50137">bb</street>

</row>

<row id="d_49ef04a0b3df4a0eb03bbe57f3a50117">

<city id="d_49ef04a0b3df4a0eb03bbe57f3a50127">aaa</city>

<street id="d_49ef04a0b3df4a0eb03bbe57f3a50137">bbb</street>

</row>

</address>

</applicationdata>

---

宝剑锋从磨砺出,梅花香自苦寒来! --- china

SQL Server  >  SQL Server XML