22,199
社区成员
发帖
与我相关
我的任务
分享
use [northwind]
go
select 1 as tag,
null as parent,
'2010-01-01' as [root!1!startDate],
'2010-01-01' as [root!1!endDate],
null as [table!2!name],
null as [record!3],
null as [field!4!name],
null as [field!4!type],
null as [field!4]
union all
select 2,1,'','', 'tablename','' ,'','',''
union
select 3,2,'','', '','' ,'' ,'',''
union
select 4,3,'','','','',ContactName ,City,customerid
from customers
FOR XML EXPLICIT
XML_F52E2B61-18A1-11d1-B105-00805F49916B
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
<root startDate="2010-01-01" endDate="2010-01-01"><table name="tablename"><record><field name="Alejandra Camino" type="Madrid">ROMEY</field><field name="Alexander Feuer" type="Leipzig">MORGK</field><field name="Ana Trujillo" type="México D.F.">ANATR</field
me="Henriette Pfalzheim" type="Köln">OTTIK</field><field name="Horst Kloss" type="Cunewalde">QUICK</field><field name="Howard Snyder" type="Eugene">GREAL</field><field name="Isabel de Castro" type="Lisboa">PRINI</field><field name="Jaime Yorres" type="San
ork">HUNGO</field><field name="Patricio Simpson" type="Buenos Aires">CACTU</field><field name="Paul Henriot" type="Reims">VINET</field><field name="Paula Parente" type="Resende">WELLI</field><field name="Paula Wilson" type="Albuquerque">RATTC</field><field
(所影响的行数为 94 行)