Vikas Singh

Vikas Singh

  • 1.3k
  • 413
  • 15.1k

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


Answers (1)