/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

0 vote204 views1 answer
Sql set data from a select query to a temp table and insert
SQL
0 vote205 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
4 votes187 views2 answers
How to delete row in sql
SQL
0 vote204 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote204 views1 answer
Como hacer un select entre fechas mysql
SQL
9 votes234 views3 answers
Pyodbc connect to sql server
SQL
49 votes204 views6 answers
Alter table add column
SQL
0 vote201 views1 answer
Grant access on table in oracle
SQL
0 vote228 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
0 vote200 views1 answer
Tsql default value when no value returned by query
SQL