/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

20 votes120 views5 answers
Mysql reset auto increment to 1
SQL
3 votes182 views2 answers
Oracle privileges users
SQL
1 vote110 views3 answers
Postgresql connect to database
SQL
1 vote139 views3 answers
Date_add mysql
SQL
0 vote124 views1 answer
Mssql check if date is greater than today
SQL
0 vote117 views1 answer
Change schema of all tables postgres
SQL
0 vote111 views1 answer
Sql compound operators
SQL
0 vote125 views1 answer
Postgresql import data from csv
SQL
6 votes123 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
0 vote113 views1 answer
Sql server 2012 create or alter procedure
SQL