adding xml tags using sql

[sds814]

I have a sql query that is producing a xml tree from the sql tables. Now I need to append an xml tag to the xml tree.

Is there an easy way to do that?

The way that I found out through googling is to convert the xml tree to a string and concatenante the strings together (xml tree with the new xml tag that I need to add). The problem with that is that when I cast the xml tree as nvarchar(max) the xml is getting truncated as noted in this post (

http://www.sqlservercentral.com/Forums/Topic623774-21-1.aspx#bm705941).

I'm hoping SQL 2005 has an easier way to append xml tags.

 

[markros]

Check if this thread

http://social.msdn.microsoft.com/Fo...49eba46/#f591b3c3-ad21-4241-b393-a32169561eab

can be of help.

PluralSight Learning Library

 

[sds814]

What I'm trying to do seems simpler.

I'm trying to add '<?xml version="1.0" encoding="utf-8"?>'
to the results of this:

SELECT TOP 10 LOAN_ID
FROM TMSMTG AS LOAN
WHERE EFF_DT = '12/31/2010'
FOR XML AUTO, TYPE, ROOT('LoanData')