Fetch SQL results in XML format

DECLARE @Employee TABLE (id Bigint IDENTITY(1,1), Name NVARCHAR(50))
INSERT INTO @Employee (name) SELECT 'ABC'
INSERT INTO @Employee (name) SELECT 'DEF'
INSERT INTO @Employee (name) SELECT 'GHI'
INSERT INTO @Employee (name) SELECT 'JKL'
INSERT INTO @Employee (name) SELECT 'MNO'


select * from @Employee For XML Path('Employee')

<Employee>
  <id>1</id>
  <Name>ABC</Name>
</Employee>
<Employee>
  <id>2</id>
  <Name>DEF</Name>
</Employee>
<Employee>
  <id>3</id>
  <Name>GHI</Name>
</Employee>
<Employee>
  <id>4</id>
  <Name>JKL</Name>
</Employee>
<Employee>
  <id>5</id>
  <Name>MNO</Name>
</Employee>

select * from @Employee For XML RAW('Employee')

<Employee id="1" Name="ABC" />
<Employee id="2" Name="DEF" />
<Employee id="3" Name="GHI" />
<Employee id="4" Name="JKL" />
<Employee id="5" Name="MNO" />

select * from @Employee For XML AUTO

<_x0040_Employee id="1" Name="ABC" />
<_x0040_Employee id="2" Name="DEF" />
<_x0040_Employee id="3" Name="GHI" />
<_x0040_Employee id="4" Name="JKL" />
<_x0040_Employee id="5" Name="MNO" />