Jan 9, 2009

Create procedure to get XML output in sqlserver 2005

CREATE PROCEDURE [dbo].[GetUsersXML]

AS
BEGIN
SELECT 1 AS TAG,
NULL AS PARENT,
UserID AS [User!1!ID],
UserName AS [User!1!Name]
FROM T_Users
FOR XML EXPLICIT
END