See below Query:
SELECT *
FROM dbo.Users
FOR XML PATH('User'), ROOT ('Users')Results: (XML Format)
<Users>
<User>
<UserID>8eaf6426-63e4-49c7-939e-1b0f43586084</UserID>
<RoleID>4</RoleID>
<FirstName>Thomas</FirstName>
<LastName>Dalm</LastName>
<Password>iJletJwlcqUrAIC98rggvA==</Password>
<EmailID>[email protected]</EmailID>
<CreatedDate>2013-05-29T06:39:48.217</CreatedDate>
<IsActive>1</IsActive>
<CompanyName>EDUDOTNET</CompanyName>
<LastPasswordChangedDate>2013-07-1T08:31:14.150</LastPasswordChangedDate>
</User>
<User>
<UserID>1e922995-d0f9-e211-b767-3c4a92dbc8db</UserID>
<RoleID>1</RoleID>
<FirstName>Khumesh</FirstName>
<LastName>Kumawat</LastName>
<Password>iJletJwlcqUrAIC98rggvA==</Password>
<EmailID>[email protected]</EmailID>
<CreatedDate>2013-05-29T06:39:48.217</CreatedDate>
<IsActive>1</IsActive>
<CompanyName>EDUDOTNET</CompanyName>
<LastPasswordChangedDate>2013-07-1T08:31:14.150</LastPasswordChangedDate>
</User>
</Users>