title: SQL Server Stored Procs include file statement
body: <p>I don't think it is possible to do so what I would but I ask anyway.</p>
  
  <p>I've found that I include the same variables in the top of every Stored Proc I make.
  These variables are used for logging and error handling. They don't change between stored procs, there meaning if fixed but primary use is to help readability and have a consistent style.</p>
  
  <pre><code>-- Declare code that resolve to possible Error
  DECLARE @CONFLICT_CODE AS INT 
  SET @CONFLICT_CODE= -99
  
  -- Check for Conflict
  IF Found &gt; 0
  BEGIN
      SELECT  @Error = @CONFLICT_CODE
  END
  </code></pre>
  
  <p>I would be great to define these in a file that I could include into the stored proc.</p>
  
  <p>I'm developing on SQL Server 2008 deploying to SQL Server 2005</p>