How to create an xml file from DB Table?

[Just Copy & Paste]

declare
@Employee Table(EmployeeID int,EmployeeName varchar(50))

insert into @Employee(EmployeeID,EmployeeName) values(101,'Manish')
insert into @Employee(EmployeeID,EmployeeName) values(102,'Arun')
insert into @Employee(EmployeeID,EmployeeName) values(103,'Priya')
insert into @Employee(EmployeeID,EmployeeName) values(104,'Kumar')
insert into @Employee(EmployeeID,EmployeeName) values(105,'Asish')
insert into @Employee(EmployeeID,EmployeeName) values(106,'Rasna')

SELECT EmployeeID,EmployeeName FROM @Employee FOR XML RAW

SELECT EmployeeID,EmployeeName FROM @Employee for Xml RAW,elements,root('EmployeeInfo')

-- [Auto : means it will make the node name as TableName(@Employee)]

SELECT EmployeeID,EmployeeName FROM @Employee FOR XML Auto

SELECT EmployeeID,EmployeeName FROM @Employee for Xml AUTO,elements,root('EmployeeInfo')