Convert Tables into XML in SQL Server

Hi makenzi.exc,

Use FOR XML.

For more details refer FOR XML.

Database

For this example I have used of Northwind database that you can download using the link given below.

Download Northwind Database

SQL

SELECT EmployeeID, 
	   CONCAT(FirstName, '', LastName) 'Name', 
	   Country 
FROM Employees
FOR XML PATH ('Employee'), ROOT('Employees')

Generated XML

<Employees>
  <Employee>
    <EmployeeID>1</EmployeeID>
    <Name>NancyDavolio</Name>
    <Country>USA</Country>
  </Employee>
  <Employee>
    <EmployeeID>2</EmployeeID>
    <Name>AndrewFuller</Name>
    <Country>USA</Country>
  </Employee>
  <Employee>
    <EmployeeID>3</EmployeeID>
    <Name>JanetLeverling</Name>
    <Country>USA</Country>
  </Employee>
  <Employee>
    <EmployeeID>4</EmployeeID>
    <Name>MargaretPeacock</Name>
    <Country>USA</Country>
  </Employee>
  <Employee>
    <EmployeeID>5</EmployeeID>
    <Name>StevenBuchanan</Name>
    <Country>UK</Country>
  </Employee>
  <Employee>
    <EmployeeID>6</EmployeeID>
    <Name>MichaelSuyama</Name>
    <Country>UK</Country>
  </Employee>
  <Employee>
    <EmployeeID>7</EmployeeID>
    <Name>RobertKing</Name>
    <Country>UK</Country>
  </Employee>
  <Employee>
    <EmployeeID>8</EmployeeID>
    <Name>LauraCallahan</Name>
    <Country>USA</Country>
  </Employee>
  <Employee>
    <EmployeeID>9</EmployeeID>
    <Name>AnneDodsworth</Name>
    <Country>UK</Country>
  </Employee>
</Employees>