select TABLE1.*,TABLE2.*,TABLE3.*
from TABLE1,TABLE2,TABLE3
FOR XML auto, ELEMENTS XSINIL
生成的XML文档TABLE3为TABLE2的子元素,TABLE2为TABLE1的子元素,
各位大虾有什么办法生成的XML文档让TABLE2和TABLE3平级都为TABLE1的子元素?
from TABLE1,TABLE2,TABLE3
FOR XML auto, ELEMENTS XSINIL
生成的XML文档TABLE3为TABLE2的子元素,TABLE2为TABLE1的子元素,
各位大虾有什么办法生成的XML文档让TABLE2和TABLE3平级都为TABLE1的子元素?
table_name = O.name,
C.col_name,
C.type_name
FROM dbo.sysobjects O,
(
SELECT
C.id,
col_name = C.name,
type_name = T.name
FROM dbo.syscolumns C, dbo.systypes T
WHERE C.xusertype = T.xusertype
)C
WHERE O.id = C.id
ORDER BY O.name, C.col_name
FOR XML AUTO, ELEMENTS XSINIL
<table_name>MSdistributor_access</table_name>
<C>
<col_name>agent_id</col_name>
<type_name>int</type_name>
</C>
<C>
<col_name>agent_type</col_name>
<type_name>int</type_name>
</C>
<C>
<col_name>db_id</col_name>
<type_name>int</type_name>
</C>
<C>
<col_name>login_time</col_name>
<type_name>datetime</type_name>
</C>
<C>
<col_name>publication_id</col_name>
<type_name>int</type_name>
</C>
<C>
<col_name>spid</col_name>
<type_name>int</type_name>
</C>
</O>