Vikas Singh

Vikas Singh

  • 1.3k
  • 412
  • 15k

want to download xml file after the stored procedure execute

Nov 28 2024 3:12 PM

want to download xml file when stored procedure executes.

when i am executing this procedure it returns output in xml format. I want it automatically download xml file after execution. 

Create PROCEDURE GetEmployeeData
AS
BEGIN
    SELECT * FROM tblemployee
    FOR XML Path('Employee'), ROOT('EmployeesDetails'), ELEMENTS 
END