title: Return empty or null fields as <element /> from SQL Server 2008 R2 with FOR XML
body: <p>I am running a query from SQL Server 2008 R2 using <code>FOR XML PATH</code>. My only issue is that I want ALL elements to appear, even if they are NULL and I want empty (or null) elements to return as </p>
  
  <pre><code>&lt;MyElement /&gt;
  </code></pre>
  
  <p>Not as</p>
  
  <pre><code>&lt;MyElement&gt;&lt;/MyElement&gt;
  </code></pre>