FOR XML CLAUSE IN SQL SERVER

THROWS A XML FORMAT RESULT 

TRY FOLLOWING 

1. Select * from EMployee for xml raw

2. select * from employee for xml raw('RajanStark'),root

3.select * from Employee  for xml raw('RajanStark'),ROOT('RAJAN')

4. select * from Employee  for xml raw('RajanStark'),ROOT('RAJAN'), ELEMENTS