/SQL/Extract Data from SQL Server into XML Format

Extract Data from SQL Server into XML Format

--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>

-1

Source: stackoverflow.com

Similar codes

9 votes279 views2 answers
Sql limit to 5 results
SQL
3 votes274 views3 answers
Create a view postgres
SQL
0 vote296 views2 answers
Select last 30 days sql
SQL
0 vote291 views1 answer
Allow null in psql
SQL
0 vote268 views1 answer
Mysql change timestamp on update
SQL
2 votes306 views1 answer
Drop all foreign key constraints mysql
SQL
11 votes295 views1 answer
Oracle insert from select
SQL
23 votes298 views4 answers
How to show all users in mysql
SQL
1 vote299 views1 answer
Psql view enum values
SQL
0 vote280 views1 answer
To_date sql
SQL