请问下, 在SQL Server 2005 或 2008SELECT *
FROM Table1
FOR XML AUTO, Root('root')将显示:<root>
<XX/>
<XXX/>
</root>目标:<root name='AA' email='bb'>
<XX/>
<XXX/>
</root>即给root 节点加属性,怎么加啊???
FROM Table1
FOR XML AUTO, Root('root')将显示:<root>
<XX/>
<XXX/>
</root>目标:<root name='AA' email='bb'>
<XX/>
<XXX/>
</root>即给root 节点加属性,怎么加啊???
IF OBJECT_ID('T1') IS NOT NULL DROP TABLE T1
IF OBJECT_ID('T2') IS NOT NULL DROP TABLE T2
GO
CREATE TABLE T1(COL1 INT,COL2 VARCHAR(50))
INSERT INTO T1
SELECT 1,'A' UNION SELECT 2,'B' UNION SELECT 3,'C'SELECT *
FROM
(SELECT 'X' 'COL3','Y' 'COL4') [ROOT]
RIGHT JOIN
(
SELECT T1.COL1,T1.COL2
FROM T1) T2 ON 1=1
FOR XML AUTO
/*
<ROOT COL3="X" COL4="Y"><T2 COL1="1" COL2="A"/><T2 COL1="2" COL2="B"/><T2 COL1="3" COL2="C"/></ROOT>
*/
http://topic.csdn.net/u/20081107/17/68aaf5a9-c596-4ab5-ae18-f3370b2ab35b.html