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

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.id,emp.name
  FROM Employee emp 

    FOR XML  PATH ('Entry') ,ROOT('XML')

 
 
  -- execute sproc sp_GetExplicitXML
  exec sp_GetExplicitXML