SELECT * FROM dbo.SystemAudit
FOR XML AUTO, TYPE, ELEMENTS XSINIL
XSINIL — for null values to show – which produces — <Notes xsi:nil=”true” />
–, ROOT(‘Pipeline’)
sql for everyone
SELECT * FROM dbo.SystemAudit
FOR XML AUTO, TYPE, ELEMENTS XSINIL
XSINIL — for null values to show – which produces — <Notes xsi:nil=”true” />
–, ROOT(‘Pipeline’)