表中有字段ID,ShopUrl,查询分析器中执行语句:
SELECT
1 as Tag,
null as Parent,
id as [site!1!ID],
shopurl as [site!1!ShopUrl]
FROM TBL_Shop
order by ID
FOR XML EXPLICIT
生成的文本结果导出即可。
表中有字段ID,ShopUrl,查询分析器中执行语句:
SELECT
1 as Tag,
null as Parent,
id as [site!1!ID],
shopurl as [site!1!ShopUrl]
FROM TBL_Shop
order by ID
FOR XML EXPLICIT
生成的文本结果导出即可。