/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

7 votes286 views2 answers
Oracle sql drop index
SQL
0 vote262 views1 answer
Sql select non unique
SQL
1 vote272 views1 answer
Ef core 5.0 usesqlserver not found
SQL
1 vote266 views6 answers
In sql
SQL
0 vote275 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
2 votes306 views1 answer
Rails execute sql
SQL
0 vote318 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
12 votes280 views4 answers
Import mysql database command line linux
SQL
0 vote276 views1 answer
Sql decode
SQL
0 vote270 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL