title: Query all XML files in a directory from SQL Server
body: <p>Given a folder full of simple XML documents that all have the same structure, is there a quick way to either load all the documents into a temporary table or treat the folder as a table, in order to query the documents with the SQL 2005 XML query syntax?</p>
  
  <p>The bulk load examples that I have seen, all try to parse the XML document while loading. For me this is not necessary as I am happy for the whole file to be treated as a single column of type 'xml'. The parsing will be handled by the query syntax.</p>