How to create a XML file using T-SQL?

[Just copy & paste]

SELECT
(
SELECT 'Ramu' AS Name,'IT' AS Department FOR XML PATH ('Employee'),
TYPE
),
(
SELECT 'Anil' AS Name,'HR' AS Department FOR XML PATH('Employee'),
TYPE
),
(
SELECT 'Raj' AS Name, 'Fin' AS Department FOR XML PATH('Employee'),
TYPE
),
(
SELECT 'Kunal' AS Name,'S/W' AS Department FOR XML PATH('Employee'),
TYPE
)
FOR XML PATH(''),
ROOT('EmployeeInfo')