sql server 2008 table convert to xml files

shannya

Ingo

shannya wrote:

sql server 2008 table convert to xml files

Is that a statement or a question? If it's a statement, tell us more. If it's a question look herehere. :rolleyes: By the way, it would be more polite to tell us what do you want to know and ask a real question. :thumbsup:

------------------------------ Author of Primary ROleplaying SysTem How do I take my coffee? Black as midnight on a moonless night. War doesn't determine who's right. War determines who's left.

kankeyan

select*from <Table Name> for xml path ('Head') select*from <Table Name> for xml path ('Head') ,root('Title') select*from <Table Name> for xml raw try like this there are more formats

Ingo

Seems that you inserted html code that corrupts the output of codeproject. The topics after yours are missing and if I open your answer I see the others again but displayed wrong!

------------------------------ Author of Primary ROleplaying SysTem How do I take my coffee? Black as midnight on a moonless night. War doesn't determine who's right. War determines who's left.

jeeteshsrivastava

asdf

kankeyan

select*from for xml path ('Head') select*from for xml path ('Head') ,root('Title') select*from for xml raw try like this there are more formats

kankeyan

Select * from for xml path('Head') select * from for xml path('Head'),root('title') select * from for xml raw there are more formats like elements

Joy Sinha

(SELECT * from [db].[schema].[tbl] FOR XML PATH(''),ROOT(''))