title: Is there a T-SQL equivalent for #include, and why
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/3243139/constants-and-include-files-in-tsql">Constants and Include files in TSQL</a>  </p>
  </blockquote>
  
  
  
  <p>I've been looking for a T-SQL equivalent of the C "#include" directive. As I haven't found, I wonder</p>
  
  <ul>
  <li>Is it possible that MS did not include any sort of SQL files inclusion / joined execution</li>
  <li>If not, why</li>
  <li>If not, is there any better way for me to execute several SQL files at once without copy-paste or manual precompilation</li>
  </ul>
  
  <p>For those curious of my motivations, I am writing a set of similar queries, and I find it convenient to externalize constants (from enum tables), pre-computations (making some test input tables) and parameter variables (which subsets I'm working on). </p>
  
  <p>As far as I know, I can't really use stored procedures or functions for that (And I don't like the idea of polluting my DB with those).</p>