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’)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.