将SQl脚本转换为XML文件 [英] conversion of SQl Script to XML File

问题描述

朋友们，


我是xml sql的新手.我需要从sql脚本生成xml文件，以使

Hi friends,


I''m new to xml sql. I need to generate a xml file from sql script in such a that

<country name="INDIA">
        <state>Andhra Pradesh</state>
        <state>Arunachal Pradesh</state>
        <state>Assam</state>

推荐答案

如果已安装AdventureWorks DB，则尝试使用SQL语句学习生成XML输出:

If you have AdventureWorks DB installed then try to use SQL statement to learn producing XML output :

USE AdventureWorks
SELECT
(
SELECT TOP 2
'AdventureWorks' AS '@Table'
,'E' AS '@ChangeType'
,'ContactID' AS 'Column/@Name'
, c.ContactID AS 'Column/*'
, NULL
,'FirstName' AS 'Column/@Name'
, c.FirstName AS 'Column/*'
, NULL
,'LastName' AS 'Column/@Name'
, c.LastName AS 'Column/*'
, NULL
,'Phone' AS 'Column/@Name'
, c.Phone AS 'Column/*'
, NULL
FROM Person.Contact c
ORDER BY ContactID
FOR XML PATH('DataRow'), Type
)
FOR XML PATH('Root')

希望对您有所帮助.

Hope it helps.

这篇关于将SQl脚本转换为XML文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！