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

Question

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 Farukh

Aarti · Answer

Hi Farukh I had tried this: -- create a table create table Employee(id int name varchar(10)); -- insert data into table insert into Employee values(1'df')(2'fg')(3'sfs')(4'dd'); --- check rows in table select * from Employee -- sproc to get sql output in XML CREATE PROCEDURE sp_GetExplicitXML AS SELECT emp.idemp.name FROM Employee emp FOR XML PATH ('Entry') ROOT('XML') -- execute sproc sp_GetExplicitXML exec sp_GetExplicitXML

Aarti · Answer

Its my goodness...

Farukh Mujawar · Answer

Thanks vikarnt and Aarti. Aarti i tried ur code its working thanks a lot ones again.

Vikrant Jadhav · Answer

Hi Farukh It is possible to get Output in XML format after execution of Store Procedure. Refer the following link http://www.perfectxml.com/Articles/XML/ExportSQLXML.asp T hanks & Regards Vikrant Jadhav If this post is helpful to you then Mark as a Correct Answer.