File using XML Data Type

CREATE TABLE #temp
(
id INT IDENTITY(1, 1) ,
varName VARCHAR(20)
)

INSERT INTO #temp(varName )VALUES ('Nirav')
INSERT INTO #temp(varName )VALUES ('Mayank')
INSERT INTO #temp(varName )VALUES ('Vihar')
INSERT INTO #temp(varName )VALUES ('Rahul')
INSERT INTO #temp(varName )VALUES ('Nilay')

SELECT * FROM #temp

DECLARE @data AS XML

SELECT @data = ( SELECT * FROM #temp
FOR XML PATH('Child') ,ROOT('Roots') )

SELECT @data