How to perform msSQL save xml file?

Asked By Ava larry 10 points N/A Posted on - 10/23/2012

Hello experts,

How to perform mssql save xml file? I am just a newbie in the world of mssql database server but willing to learn and explore more in the world of technology. Can you give me some steps to be followed on how to save xml file? Thank you experts.

• Status: Open
• Question Views: 1346
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Sierra Adams 10 points N/A #179727

How to perform msSQL save xml file?

Hi,

Don’t worry, it’s very easy. In Microsoft 2005, there are many XML extensions that make it easy to play with XML and database. There are many keywords like auto, raw, elements, Root and data. You can use these are save your XML by setting the output to the XML file and running a query. For example check this query.

 

• Select First Name, Last Name, Phone, Email, Address
• From Employees
• For XML AUTO, elements

 

This query will return all the rows as parent row and columns as a child node for each row and row node will be of Employee type.

I hope this will helps you.

 

Thank you.

About Sierra Adams

Questions
1

Answers
101

Best Answers
39

• Vote Up 0 Vote Down

• Posted on - 10/26/2012
• Question Category: MS SQL Server