title: In SQLServer 2012 TSQL, what's the difference of using XML RAW, XML AUTO and XML PATH
body: <p>As the title, all open minds are welcomed</p>
  
  <p>I tested in my computer, the output seems to be the same.</p>
  
  <p>For example.</p>
  
  <pre><code>USE BOB_DATABASE
  SELECT ID, Name, First_Name, Last_Name FROM DBO.T_User
  FOR XML AUTO
  
  USE BOB_DATABASE
  SELECT ID, Name, First_Name, Last_Name FROM DBO.T_User
  FOR XML RAW
  
  USE BOB_DATABASE
  SELECT ID, Name, First_Name, Last_Name FROM DBO.T_User
  FOR XML RAW, ELEMENTS
  
  USE BOB_DATABASE
  SELECT ID, Name, First_Name, Last_Name FROM DBO.T_User
  FOR XML PATH('CUSTOMERS')
  </code></pre>