conversion of SQl Script to XML File

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

Hi friends,

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

XML

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

How can write a script for getting this.

Posted 13-Dec-11 17:52pm

jagadeesh123qqq

Add a Solution

Comments

Sergey Alexandrovich Kryukov 14-Dec-11 0:03am

OK, this is the sample of output. What was supposed to by on input? A script?! How and what is it? More importantly -- why?
--SA

jagadeesh123qqq 14-Dec-11 0:09am

Thanks for your reply...
My script is ...
SELECT Col_code,Col_name FROM
(select D.dist_name,C.Col_code,Col_name from college C
INNER JOIN District D oN C.District=D.Dist_code) D
where Dist_name LIKE 'Baga%'
GROUP BY Dist_name,Col_code,Col_name

For XML AUTO,ELEMENTS

i am binding list of colleges at client side to dropdownlist

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Amir Mahfoozi · Answer 1 · 2011-12-13T18:25:00

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

SQL

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.

conversion of SQl Script to XML File

1 solution

Solution 1

Add your solution here

Preview 0

conversion of SQl Script to XML File

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us