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')
Result will be
<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')
Result will be
<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
Result will be
<_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" />