Export data from SQL Server as XML

SELECT * FROM dbo.SystemAudit
FOR XML AUTO, TYPE, ELEMENTS XSINIL

XSINIL — for null values to show – which produces — <Notes xsi:nil=”true” />

–, ROOT(‘Pipeline’)