XML in SQL

select * from users for XML Raw
select * from users for XML Raw, TYPE
select * from users for XML AUTO, TYPE
select * from users for XML AUTO, ELEMENTS
select * from users for XML PATH
CDATA
select 1 as Tag,0 as Parent,User_fname as [usr!1!User_fname],User_lname as [usr!1!User_lname] from users for XML EXPLICIT
elementxsinil
select 1 as Tag,0 as Parent,User_fname as [usr!1!User_fname!ELEMENT],User_lname as [usr!1!User_lname!ELEMENT] from users for XML EXPLICIT

http://books.google.co.in/books?id=Yvkbvty20PgC&pg=PA148&lpg=PA148&dq=select+*+from+users+for+XML+Raw&source=bl&ots=CCofDnw9I9&sig=Rn7-UZMkNEaNUI9L-iJaXjGS4q0&hl=en&ei=1Y3NSrehOo_xkAXzmbzsAw&sa=X&oi=book_result&ct=result&resnum=8#v=onepage&q=&f=false