Breaking News: Grepper is joining You.com. Read the official announcement!

Extract Data from SQL Server into XML Format

Add Answer

Stun Dexim answered on October 18, 2021 Popularity 7/10 Helpfulness 1/10

answer Extract Data from SQL Server into XML Format

related convert sql query to xml format

Extract Data from SQL Server into XML Format

Comment

-1

--SQL Code extract to XML format w/ more explicite and well formed tags than just using "For XML Auto"
    SELECT 
        [EmployeeID] AS '@ID',
        [LastName], [FirstName],
        [Title],
        [BirthDate], [HireDate]
    FROM 
        [dbo].[Employees]
    FOR XML PATH('Employee'), ROOT('Employees')


--Output of This SQL below
    <Employees>
      <Employee ID="1">
        <LastName>Davolio</LastName>
        <FirstName>Nancy</FirstName>
        <Title>Sales Representative</Title>
        <BirthDate>1948-12-08T00:00:00</BirthDate>
        <HireDate>1992-05-01T00:00:00</HireDate>
      </Employee>
      <Employee ID="2">
        <LastName>Fuller</LastName>
        <FirstName>Andrew</FirstName>
        <Title>Vice President, Sales</Title>
        <BirthDate>1952-02-19T00:00:00</BirthDate>
        <HireDate>1992-08-14T00:00:00</HireDate>
      </Employee>

Popularity 7/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: extract format sql sql-server xml

Link to this answer
Share Copy Link

Contributed on Oct 18 2021

Stun Dexim

0 Answers Avg Quality 2/10

Closely Related Answers

convert sql query to xml format

Comment

-- Use FOR XML PATH('Customer')

SELECT 
   CustomerID as "@CustomerID",
   CompanyName,
   Address as "address/street",
   City as "address/city",
   Region as "address/region",
   PostalCode as "address/zip",
   Country as "address/country",
   ContactName as "contact/name",
   ContactTitle as "contact/title",
   Phone as "contact/phone", 
   Fax as "contact/fax"
FROM Customers
FOR XML PATH('Customer')

-- will result in

  <Customer CustomerID="ALFKI">
    <CompanyName>Alfreds Futterkiste</CompanyName>
    <address>
      <street>Obere Str. 57</street>
      <city>Berlin</city>
      <zip>12209</zip>
      <country>Germany</country>
    </address>
    <contact>
      <name>Maria Anders</name>
      <title>Sales Representative</title>
      <phone>030-0074321</phone>
      <fax>030-0076545</fax>
    </contact>
  </Customer>

Popularity 9/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: xml sql format form

Link to this answer
Share Copy Link

Contributed on Sep 13 2022

Elliot Cullen

0 Answers Avg Quality 2/10

Extract Data from SQL Server into XML Format

Contents

More Related Answers

Extract Data from SQL Server into XML Format

Closely Related Answers

convert sql query to xml format

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.