How to generate a xml doc using from database using T-sql

You can use bcp to export the data, this link will help you,

http://msdn.microsoft.com/en-us/library/ms191184.aspx#bulk_export_xml_data

---

Thanks & Regards RAJUKIRAN L Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers.