Is there a way to export XML from SQL using a stored procedure?

Dec 23 2011 2:21 AM

Dear All,
In general when we execute stored procedure we will get output in tabular format but here question is we want output in XML format. Is this possible or if it is possible then how?
Thanks in advance.

Thanks & Regards