Posted onOctober 22, 2014 by Josephine 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’)