Stored Procedure to return XML data from select query in sql server.

--— =============================================

--— Author:ABC

--— Create date: Date

--— Description: Decs

--— =============================================

CREATE procedure   sp_GetEmployeeList

(

@EmpId int=null

)

as

begin

select  EmpId,Name,City,Telephone

from Employee

where   EmpId=@EmpId

order by Name

for XML AUTO, ROOT('Employees')

end